APPS.HR_US_W2_MT dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 328: l_report_format pay_report_format_mappings_f.report_format%type;

324: l_effective_date DATE; /* 4152323 variables definitions start */
325: l_report_type pay_payroll_actions.report_type%type;
326: l_report_category pay_payroll_actions.report_category%type;
327: l_report_qualifier pay_payroll_actions.report_qualifier%type;
328: l_report_format pay_report_format_mappings_f.report_format%type;
329: l_range_person_on BOOLEAN;
330:
331: l_procedure_name VARCHAR2(100);
332:

Line 409: from pay_report_format_mappings_f

405:
406: Begin
407: select report_format
408: into l_report_format
409: from pay_report_format_mappings_f
410: where report_type = l_report_type
411: and report_qualifier = l_report_qualifier
412: and report_category = l_report_category
413: and l_effective_date between

Line 1365: l_report_format pay_report_format_mappings_f.report_format%type;

1361: l_effective_date DATE; /* 4152323 variables definitions start */
1362: l_report_type pay_payroll_actions.report_type%type;
1363: l_report_category pay_payroll_actions.report_category%type;
1364: l_report_qualifier pay_payroll_actions.report_qualifier%type;
1365: l_report_format pay_report_format_mappings_f.report_format%type;
1366: l_range_person_on BOOLEAN;
1367: /* 4152323 variables definitions end */
1368:
1369: CURSOR c_state_context (p_context_name varchar2) is

Line 1456: from pay_report_format_mappings_f

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