DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 399: l_report_format pay_report_format_mappings_f.report_format%type;

395: -- Variables declared for bug 10399514
396: l_person_on boolean ;
397: l_report_cat pay_payroll_actions.report_category%type;
398: l_state pay_payroll_actions.report_qualifier%type;
399: l_report_format pay_report_format_mappings_f.report_format%type;
400: -- Variables declared for bug 10399514
401:
402: ln_rep_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
403: ln_arch_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;

Line 1213: from pay_report_format_mappings_f

1209:
1210: Begin
1211: select report_format
1212: into l_report_format
1213: from pay_report_format_mappings_f
1214: where report_type = lv_ppr_report_type
1215: and report_qualifier = l_state
1216: and report_category = l_report_cat ;
1217: Exception