APPS.HR_US_W2_MT dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 337: l_report_format pay_report_format_mappings_f.report_format%type;

333: l_effective_date DATE; /* 4152323 variables definitions start */
334: l_report_type pay_payroll_actions.report_type%type;
335: l_report_category pay_payroll_actions.report_category%type;
336: l_report_qualifier pay_payroll_actions.report_qualifier%type;
337: l_report_format pay_report_format_mappings_f.report_format%type;
338: l_range_person_on BOOLEAN;
339:
340: l_procedure_name VARCHAR2(100);
341:

Line 418: from pay_report_format_mappings_f

414:
415: Begin
416: select report_format
417: into l_report_format
418: from pay_report_format_mappings_f
419: where report_type = l_report_type
420: and report_qualifier = l_report_qualifier
421: and report_category = l_report_category
422: and l_effective_date between

Line 1359: l_report_format pay_report_format_mappings_f.report_format%type;

1355: l_effective_date DATE; /* 4152323 variables definitions start */
1356: l_report_type pay_payroll_actions.report_type%type;
1357: l_report_category pay_payroll_actions.report_category%type;
1358: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1359: l_report_format pay_report_format_mappings_f.report_format%type;
1360: l_range_person_on BOOLEAN;
1361: /* 4152323 variables definitions end */
1362:
1363: CURSOR c_state_context (p_context_name varchar2) is

Line 1453: from pay_report_format_mappings_f

1449:
1450: Begin
1451: select report_format
1452: into l_report_format
1453: from pay_report_format_mappings_f
1454: where report_type = l_report_type
1455: and report_qualifier = l_report_qualifier
1456: and report_category = l_report_category
1457: and l_effective_date between