DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;

171: lv_sin per_all_people_f.national_identifier%TYPE;
172: lv_year VARCHAR2(4);
173: lv_report_type1 pay_payroll_actions.report_type%TYPE;
174: lv_state1 pay_payroll_actions.report_qualifier%type;
175: lv_report_cat1 pay_report_format_mappings_f.report_format%type;
176:
177: BEGIN
178: hr_utility.trace('Entered get_payroll_action_info');
179: open c_payroll_action_info(p_payroll_action_id);

Line 371: lv_report_format pay_report_format_mappings_f.report_format%type;

367: -- Variables declared for bug 10399514
368: lv_person_on boolean ;
369: lv_report_cat pay_payroll_actions.report_category%type;
370: lv_state pay_payroll_actions.report_qualifier%type;
371: lv_report_format pay_report_format_mappings_f.report_format%type;
372: -- Variables declared for bug 10399514
373:
374: CURSOR c_selected_asg_set(cp_start_person in number
375: ,cp_end_person in number

Line 616: from pay_report_format_mappings_f

612: lv_person_on := FALSE ;
613: Begin
614: select report_format
615: into lv_report_format
616: from pay_report_format_mappings_f
617: where report_type = lv_report_type
618: and report_qualifier = lv_state
619: and report_category = lv_report_cat ;
620: Exception