APPS.PAY_SA_GOSI_REPORTS dependencies on DUAL

Line 188: from dual;

184: start with pose.organization_id_parent = p_organisation_id
185: and pose.org_structure_version_id = p_org_structure_version_id
186: union
187: select p_organisation_id org
188: from dual;
189: rec_org_id csr_org_hierarchy%rowtype;
190: l_file_name varchar2(250);
191: l_audit_log_dir varchar2(500);
192: /*Cursor for fetching gosi office code*/

Line 1274: from dual;

1270: start with pose.organization_id_parent = (nvl(p_organisation_id,l_parent_id))
1271: and pose.org_structure_version_id = p_org_structure_version_id
1272: union
1273: select (nvl(p_organisation_id,l_parent_id)) org
1274: from dual;
1275: rec_org_id csr_org_hierarchy%rowtype;
1276: /*Cursor for fetching gosi office details*/
1277: cursor csr_gosi_office_details is
1278: select org_information1

Line 1429: from dual;

1425: end if;
1426: end if;*/
1427: select add_months(l_effective_date,-1)
1428: into l_prev_mon_date
1429: from dual;
1430: /* Following one line changed for enhancement 5283457
1431: l_prev_term_date := to_date('28-'||to_char(l_prev_mon_date,'MM-YYYY'),'DD-MM-YYYY');*/
1432: l_prev_term_date := last_day(l_prev_mon_date);
1433: select add_months(l_prev_mon_date,-1)

Line 1435: from dual;

1431: l_prev_term_date := to_date('28-'||to_char(l_prev_mon_date,'MM-YYYY'),'DD-MM-YYYY');*/
1432: l_prev_term_date := last_day(l_prev_mon_date);
1433: select add_months(l_prev_mon_date,-1)
1434: into l_prev2_mon_date
1435: from dual;
1436: /* Following one line changed for enhancement 5283457
1437: l_prev2_term_date := to_date('28-'||to_char(l_prev2_mon_date,'MM-YYYY'),'DD-MM-YYYY');*/
1438: l_prev2_term_date := last_day(l_prev2_mon_date);
1439: l_def_nationality_cd := UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY')); --'AM'; -- UPPER(FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY'));

Line 2864: from dual;

2860: start with pose.organization_id_parent = p_organisation_id
2861: and pose.org_structure_version_id = p_org_structure_version_id
2862: union
2863: select p_organisation_id org
2864: from dual;
2865: rec_org_id csr_org_hierarchy%rowtype;
2866: /* Cursor to fetch lower limit of gosi base*/
2867: CURSOR get_lower_base(l_effective_date DATE) IS
2868: SELECT global_value

Line 3874: select userenv('LANGUAGE') into g_nls_db_char from dual;

3870: l_raw_buffer_len pls_integer;
3871: l_blob_offset pls_integer := 1;
3872: begin
3873: hr_utility.set_location('Entered Procedure clob to blob',120);
3874: select userenv('LANGUAGE') into g_nls_db_char from dual;
3875: l_length_clob := dbms_lob.getlength(p_clob);
3876: l_offset := 1;
3877: while l_length_clob > 0 loop
3878: hr_utility.trace('l_length_clob '|| l_length_clob);