APPS.HR_NONRUN_ASACT dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;

1284: l_report_type pay_payroll_actions.report_type%type;
1285: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1286: l_report_category pay_payroll_actions.report_category%type;
1287: l_eff_date pay_payroll_actions.effective_date%type;
1288: l_temp_act_flag pay_report_format_mappings_f.temporary_action_flag%type;
1289: --
1290: begin
1291: --
1292: select action_type,

Line 1311: from pay_report_format_mappings_f

1307: if (l_action_type = 'X') then
1308: --
1309: select temporary_action_flag
1310: into l_temp_act_flag
1311: from pay_report_format_mappings_f
1312: where report_type = l_report_type
1313: and report_qualifier = l_report_qualifier
1314: and report_category = l_report_category
1315: and l_eff_date between effective_start_date

Line 4648: from pay_report_format_mappings_f prfm,

4644: statem varchar2(256);
4645: begin
4646: select assignment_action_code
4647: into action_proc
4648: from pay_report_format_mappings_f prfm,
4649: pay_payroll_actions ppa
4650: where ppa.payroll_action_id = pactid
4651: and ppa.report_type = prfm.report_type
4652: and ppa.report_qualifier = prfm.report_qualifier

Line 5239: , pay_report_format_mappings_f rfm

5235: select ppa.action_status
5236: , ppa.action_type
5237: , rfm.report_name
5238: from pay_payroll_actions ppa
5239: , pay_report_format_mappings_f rfm
5240: where ppa.payroll_action_id = p_pact_id
5241: and ppa.report_type = rfm.report_type(+)
5242: and ppa.report_qualifier = rfm.report_qualifier(+)
5243: and ppa.report_category = rfm.report_category(+);

Line 5276: l_rep_name pay_report_format_mappings_f.report_name%type;

5272: group by chunk_number) v2);
5273: --
5274: l_act_status pay_payroll_actions.action_status%type;
5275: l_act_type pay_payroll_actions.action_type%type;
5276: l_rep_name pay_report_format_mappings_f.report_name%type;
5277: l_chunk pay_assignment_actions.chunk_number%type;
5278: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
5279: --
5280: BEGIN