eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GENERIC_UPGRADE dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 300: l_report_type pay_report_format_mappings_f.report_type%type;

296: l_upg_level pay_upgrade_definitions.upgrade_level%type;
297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;
300: l_report_type pay_report_format_mappings_f.report_type%type;
301: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
302: --
303:
304: statem varchar2(2000);

Line 301: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;

297: l_bus_grp_id pay_payroll_actions.business_group_id%type;
298: l_leg_code per_business_groups.legislation_code%type;
299: l_thread_level pay_upgrade_definitions.threading_level%type;
300: l_report_type pay_report_format_mappings_f.report_type%type;
301: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
302: --
303:
304: statem varchar2(2000);
305: sql_cursor integer;

Line 316: from pay_report_format_mappings_f rf,

312: commit;
313:
314: select rf.report_type,rf.report_format_mapping_id
315: into l_report_type,l_rep_id
316: from pay_report_format_mappings_f rf,
317: pay_payroll_actions pact
318: where pact.payroll_action_id=pactid
319: and rf.report_type =pact.report_type
320: and rf.report_qualifier=pact.report_qualifier

Line 727: l_report_type pay_report_format_mappings_f.report_type%type;

723: l_upg_def_nm pay_upgrade_definitions.short_name%type;
724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;
731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;

Line 728: l_report_format pay_report_format_mappings_f.report_format%type;

724: l_upg_level pay_upgrade_definitions.upgrade_level%type;
725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;
731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
732: l_range_person boolean default FALSE; -- Variable used to check if RANGE_PERSON_ID is enabled, introduced for bug 8851143

Line 729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;

725: l_thread_level pay_upgrade_definitions.threading_level%type;
726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;
731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
732: l_range_person boolean default FALSE; -- Variable used to check if RANGE_PERSON_ID is enabled, introduced for bug 8851143
733: --

Line 730: l_report_category pay_report_format_mappings_f.report_category%type;

726: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;
731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
732: l_range_person boolean default FALSE; -- Variable used to check if RANGE_PERSON_ID is enabled, introduced for bug 8851143
733: --
734: begin

Line 731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;

727: l_report_type pay_report_format_mappings_f.report_type%type;
728: l_report_format pay_report_format_mappings_f.report_format%type;
729: l_report_qualifier pay_report_format_mappings_f.report_qualifier%type;
730: l_report_category pay_report_format_mappings_f.report_category%type;
731: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
732: l_range_person boolean default FALSE; -- Variable used to check if RANGE_PERSON_ID is enabled, introduced for bug 8851143
733: --
734: begin
735:

Line 740: from pay_report_format_mappings_f rf,

736: /* chk if generic report or generic upgrade */
737:
738: select rf.report_type, rf.report_format, rf.report_qualifier, rf.report_category, rf.report_format_mapping_id
739: into l_report_type, l_report_format, l_report_qualifier, l_report_category, l_rep_id
740: from pay_report_format_mappings_f rf,
741: pay_payroll_actions pact
742: where pact.payroll_action_id=p_pactid
743: and rf.report_type =pact.report_type
744: and rf.report_qualifier=pact.report_qualifier