APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on DUAL

Line 642: FROM DUAL;

638: NULL, 'NULL',
639: to_char(p_action_context_id))
640: INTO l_action_information_id,
641: l_action_context_id
642: FROM DUAL;
643:
644: build_sql(sqlstr, l_cntr_sql, 'declare l_org_id varchar2(100);');
645:
646: /*12636751*/

Line 723: 'hla.LOCATION_CODE=csr_get_archived_info_rec.action_information30),''K'') INTO lt_rate_flg FROM DUAL;');

719: ' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||
720: 'WHERE hle.information_type = ''HR_SELF_SERVICE_LOC_PREFERENCE''');
721: build_sql(sqlstr,l_cntr_sql,
722: 'AND hle.lei_information1 =''PAYSLIP'' AND hla.LOCATION_ID = hle.LOCATION_ID AND '||
723: 'hla.LOCATION_CODE=csr_get_archived_info_rec.action_information30),''K'') INTO lt_rate_flg FROM DUAL;');
724: build_sql(sqlstr,l_cntr_sql,
725: 'IF lt_rate_flg = ''K'' THEN');
726: build_sql(sqlstr,l_cntr_sql,
727: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

Line 730: 'AND organization_id=csr_get_archived_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');

726: build_sql(sqlstr,l_cntr_sql,
727: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
728: 'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
729: build_sql(sqlstr,l_cntr_sql,
730: 'AND organization_id=csr_get_archived_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
731: build_sql(sqlstr,l_cntr_sql,
732: 'IF lt_rate_flg = ''K'' THEN ');
733: build_sql(sqlstr,l_cntr_sql,
734: ' SELECT NVL((select org_information13 FROM hr_organization_information '||

Line 737: 'AND organization_id='||lt_per_bgId_value||'),''K'') INTO lt_rate_flg FROM DUAL;'); --Bug 16451278

733: build_sql(sqlstr,l_cntr_sql,
734: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
735: 'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
736: build_sql(sqlstr,l_cntr_sql,
737: 'AND organization_id='||lt_per_bgId_value||'),''K'') INTO lt_rate_flg FROM DUAL;'); --Bug 16451278
738: build_sql(sqlstr,l_cntr_sql,
739: 'IF lt_rate_flg = ''K'' THEN ');
740: build_sql(sqlstr,l_cntr_sql,
741: ' lt_rate_flg := ''N'';');

Line 758: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');

754: build_sql(sqlstr, l_cntr_sql, 'lt_element_type := csr_get_archived_info_rec.action_information20;');
755: build_sql(sqlstr,
756: l_cntr_sql,
757: 'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
758: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
759: build_sql(sqlstr,
760: l_cntr_sql,
761: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');
762: END IF;

Line 1381: FROM DUAL;

1377: to_char(p_pre_payment_id))
1378: INTO l_action_information_id,
1379: l_action_context_id,
1380: l_pre_payment_id
1381: FROM DUAL;
1382:
1383: build_sql(sqlstr, l_cntr_sql, 'begin ');
1384:
1385: if p_generate_header_flag then