APPS.PAY_IP_STARTUP_UTIL dependencies on PAY_REPORT_FORMAT_PARAMETERS

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 1947: UPDATE pay_report_format_parameters

1943:
1944: FOR rec IN c_report_format_parameters
1945: LOOP
1946:
1947: UPDATE pay_report_format_parameters
1948: SET parameter_value = rec.parameter_value
1949: WHERE report_format_mapping_id = ln_report_mapping_id
1950: AND parameter_name = rec.parameter_name;
1951:

Line 1953: INSERT INTO pay_report_format_parameters

1949: WHERE report_format_mapping_id = ln_report_mapping_id
1950: AND parameter_name = rec.parameter_name;
1951:
1952: IF SQL%ROWCOUNT = 0 THEN
1953: INSERT INTO pay_report_format_parameters
1954: (report_format_mapping_id, parameter_name, parameter_value)
1955: VALUES
1956: (ln_report_mapping_id, rec.parameter_name, rec.parameter_value);
1957: END IF;