APPS.PAY_GENERIC_UPGRADE dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 285: l_report_type pay_report_format_mappings_f.report_type%type;

281: l_upg_level pay_upgrade_definitions.upgrade_level%type;
282: l_bus_grp_id pay_payroll_actions.business_group_id%type;
283: l_leg_code per_business_groups.legislation_code%type;
284: l_thread_level pay_upgrade_definitions.threading_level%type;
285: l_report_type pay_report_format_mappings_f.report_type%type;
286: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
287: --
288: begin
289:

Line 286: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;

282: l_bus_grp_id pay_payroll_actions.business_group_id%type;
283: l_leg_code per_business_groups.legislation_code%type;
284: l_thread_level pay_upgrade_definitions.threading_level%type;
285: l_report_type pay_report_format_mappings_f.report_type%type;
286: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
287: --
288: begin
289:
290: /* chk if generic report or generic upgrade */

Line 295: from pay_report_format_mappings_f rf,

291: commit;
292:
293: select rf.report_type,rf.report_format_mapping_id
294: into l_report_type,l_rep_id
295: from pay_report_format_mappings_f rf,
296: pay_payroll_actions pact
297: where pact.payroll_action_id=pactid
298: and rf.report_type =pact.report_type
299: and rf.report_qualifier=pact.report_qualifier

Line 662: l_report_type pay_report_format_mappings_f.report_type%type;

658: l_upg_def_nm pay_upgrade_definitions.short_name%type;
659: l_upg_level pay_upgrade_definitions.upgrade_level%type;
660: l_thread_level pay_upgrade_definitions.threading_level%type;
661: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
662: l_report_type pay_report_format_mappings_f.report_type%type;
663: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
664: --
665: begin
666:

Line 663: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;

659: l_upg_level pay_upgrade_definitions.upgrade_level%type;
660: l_thread_level pay_upgrade_definitions.threading_level%type;
661: l_qual_proc pay_upgrade_definitions.qualifying_procedure%type;
662: l_report_type pay_report_format_mappings_f.report_type%type;
663: l_rep_id pay_report_format_mappings_f.report_format_mapping_id%type;
664: --
665: begin
666:
667: /* chk if generic report or generic upgrade */

Line 671: from pay_report_format_mappings_f rf,

667: /* chk if generic report or generic upgrade */
668:
669: select rf.report_type,rf.report_format_mapping_id
670: into l_report_type,l_rep_id
671: from pay_report_format_mappings_f rf,
672: pay_payroll_actions pact
673: where pact.payroll_action_id=p_pactid
674: and rf.report_type =pact.report_type
675: and rf.report_qualifier=pact.report_qualifier