DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 182: lv_report_cat1 pay_report_format_mappings_f.report_format%type;

178: lv_sin per_all_people_f.national_identifier%TYPE;
179: lv_year VARCHAR2(4);
180: lv_report_type1 pay_payroll_actions.report_type%TYPE;
181: lv_state1 pay_payroll_actions.report_qualifier%type;
182: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
183:
184: BEGIN
185: hr_utility.trace('Entered get_payroll_action_info');
186: open c_payroll_action_info(p_payroll_action_id);

Line 379: lv_report_format pay_report_format_mappings_f.report_format%type;

375: -- Variables declared for bug 10399514
376: lv_person_on boolean ;
377: lv_report_cat pay_payroll_actions.report_category%type;
378: lv_state pay_payroll_actions.report_qualifier%type;
379: lv_report_format pay_report_format_mappings_f.report_format%type;
380: -- Variables declared for bug 10399514
381:
382:
383: CURSOR c_selected_asg_set(cp_start_person in number

Line 635: from pay_report_format_mappings_f

631:
632: Begin
633: select report_format
634: into lv_report_format
635: from pay_report_format_mappings_f
636: where report_type = lv_report_type
637: and report_qualifier = lv_state
638: and report_category = lv_report_cat ;
639: Exception