APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 783: FROM pay_report_format_mappings_f

779: SELECT report_type, report_qualifier, report_format, effective_start_date, effective_end_date, range_code,
780: assignment_action_code, initialization_code, archive_code, magnetic_code, report_category,
781: report_name, sort_code, updatable_flag, deinitialization_code, legislation_code, last_update_date,
782: last_updated_by, last_update_login, created_by, creation_date, temporary_action_flag
783: FROM pay_report_format_mappings_f
784: WHERE nvl(report_qualifier,'X') = 'ZZ'
785: AND business_group_id IS NULL;
786:
787: CURSOR get_dimension_routes_csr IS

Line 1908: FROM pay_report_format_mappings_f

1904: PROCEDURE create_report_format_param(p_legislation_code IN VARCHAR2) IS
1905:
1906: CURSOR c_report_format_mapping IS
1907: SELECT report_format_mapping_id
1908: FROM pay_report_format_mappings_f
1909: WHERE report_qualifier = p_legislation_code
1910: AND report_type = 'IP_PAYROLL_ARCHIVE'
1911: AND report_format = 'IP_PAYROLL_ARCHIVE'
1912: AND sysdate BETWEEN effective_start_date AND effective_end_date;

Line 1916: FROM pay_report_format_parameters prfp, pay_report_format_mappings_f prfm

1912: AND sysdate BETWEEN effective_start_date AND effective_end_date;
1913:
1914: CURSOR c_report_format_parameters IS
1915: SELECT prfp.parameter_name, prfp.parameter_value
1916: FROM pay_report_format_parameters prfp, pay_report_format_mappings_f prfm
1917: WHERE prfp.report_format_mapping_id = prfm.report_format_mapping_id
1918: AND prfm.report_qualifier = 'ZZ'
1919: AND prfm.business_group_id IS NULL;
1920:

Line 1935: UPDATE pay_report_format_mappings_f

1931:
1932: SELECT PAY_REPORT_FORMAT_MAPPINGS_S.nextval
1933: INTO ln_report_mapping_id FROM dual;
1934:
1935: UPDATE pay_report_format_mappings_f
1936: SET report_format_mapping_id = ln_report_mapping_id
1937: WHERE report_qualifier = p_legislation_code
1938: AND report_type = 'IP_PAYROLL_ARCHIVE'
1939: AND report_format = 'IP_PAYROLL_ARCHIVE'