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 4663: from pay_report_format_mappings_f prfm,

4659: statem varchar2(256);
4660: begin
4661: select assignment_action_code
4662: into action_proc
4663: from pay_report_format_mappings_f prfm,
4664: pay_payroll_actions ppa
4665: where ppa.payroll_action_id = pactid
4666: and ppa.report_type = prfm.report_type
4667: and ppa.report_qualifier = prfm.report_qualifier

Line 5254: , pay_report_format_mappings_f rfm

5250: select ppa.action_status
5251: , ppa.action_type
5252: , rfm.report_name
5253: from pay_payroll_actions ppa
5254: , pay_report_format_mappings_f rfm
5255: where ppa.payroll_action_id = p_pact_id
5256: and ppa.report_type = rfm.report_type(+)
5257: and ppa.report_qualifier = rfm.report_qualifier(+)
5258: and ppa.report_category = rfm.report_category(+);

Line 5291: l_rep_name pay_report_format_mappings_f.report_name%type;

5287: group by chunk_number) v2);
5288: --
5289: l_act_status pay_payroll_actions.action_status%type;
5290: l_act_type pay_payroll_actions.action_type%type;
5291: l_rep_name pay_report_format_mappings_f.report_name%type;
5292: l_chunk pay_assignment_actions.chunk_number%type;
5293: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
5294: --
5295: BEGIN