DBA Data[Home] [Help]

APPS.PAY_DIRECT_DEPOSIT_XML dependencies on DUAL

Line 359: INTO lv_legislation_install FROM dual;

355: := 'EE';
356:
357: /*Employee Information -Legislation Specific*/
358: SELECT pay_ip_utility.get_ip_installation(ln_business_group_id)
359: INTO lv_legislation_install FROM dual;
360: /*Modified for International Payroll*/
361: IF lv_legislation_install = 'Y' THEN
362: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
363: '_RULES.add_custom_xml(:1,:2,:3); END;'

Line 595: INTO lv_legislation_install FROM dual;

591: pay_payroll_xml_extract_pkg.g_custom_params(ln_param_count).parameter_value := 'ER';
592:
593: /*Employee Information -Legislation Specific*/
594: SELECT pay_ip_utility.get_ip_installation(ln_business_group_id)
595: INTO lv_legislation_install FROM dual;
596: /*Modified for International Payroll*/
597: IF lv_legislation_install = 'Y' THEN
598: EXECUTE IMMEDIATE 'BEGIN PAY_'||pay_payroll_xml_extract_pkg.g_leg_code||
599: '_RULES.add_custom_xml(:1,:2,:3); END;'