APPS.PAY_ARCHIVE dependencies on PAY_REPORT_FORMAT_MAPPINGS

Line 113: l_report_format pay_report_format_mappings_f.report_format%TYPE;

109: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
110: l_legislation_code per_business_groups.legislation_code%TYPE;
111: l_effective_date pay_payroll_actions.effective_date%TYPE;
112: l_date_earned pay_payroll_actions.date_earned%TYPE;
113: l_report_format pay_report_format_mappings_f.report_format%TYPE;
114: l_report_type pay_report_format_mappings_f.report_type%TYPE;
115: legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
116: non_unique_con boolean := FALSE;
117: process_archive boolean := FALSE;

Line 114: l_report_type pay_report_format_mappings_f.report_type%TYPE;

110: l_legislation_code per_business_groups.legislation_code%TYPE;
111: l_effective_date pay_payroll_actions.effective_date%TYPE;
112: l_date_earned pay_payroll_actions.date_earned%TYPE;
113: l_report_format pay_report_format_mappings_f.report_format%TYPE;
114: l_report_type pay_report_format_mappings_f.report_type%TYPE;
115: legislative_parameters pay_payroll_actions.legislative_parameters%TYPE;
116: non_unique_con boolean := FALSE;
117: process_archive boolean := FALSE;
118: -----------------------------------------------------------------------

Line 482: FROM pay_report_format_mappings_f prfm,

478: ---------------------------------------------------------------------
479: -- Get format for report type and state specified.
480: SELECT prfm.report_format, pac.report_type
481: INTO l_report_format, l_report_type
482: FROM pay_report_format_mappings_f prfm,
483: pay_payroll_actions pac
484: WHERE prfm.report_type = pac.report_type
485: AND prfm.report_qualifier = pac.report_qualifier
486: AND prfm.report_category = pac.report_category

Line 496: init_proc pay_report_format_mappings.initialization_code%TYPE;

492: -- Create dynsql to invoke legislative hook
493: declare
494: sql_cur number;
495: ignore number;
496: init_proc pay_report_format_mappings.initialization_code%TYPE;
497: statem varchar2(256);
498: pactid number;
499: begin
500: pactid := l_payroll_action_id;

Line 503: from pay_report_format_mappings_f prfm,

499: begin
500: pactid := l_payroll_action_id;
501: select prfm.initialization_code
502: into init_proc
503: from pay_report_format_mappings_f prfm,
504: pay_payroll_actions ppa
505: where ppa.payroll_action_id = pactid
506: and ppa.report_type = prfm.report_type
507: and ppa.report_category = prfm.report_category

Line 595: from pay_report_format_mappings_f prfm,

591: begin
592: pactid := l_payroll_action_id;
593: select prfm.deinitialization_code
594: into deinit_proc
595: from pay_report_format_mappings_f prfm,
596: pay_payroll_actions ppa
597: where ppa.payroll_action_id = pactid
598: and ppa.report_type = prfm.report_type
599: and ppa.report_category = prfm.report_category

Line 1082: from pay_report_format_mappings_f prfm,

1078: begin
1079: pactid := p_payroll_action_id;
1080: select prfm.archive_code
1081: into archiv_proc
1082: from pay_report_format_mappings_f prfm,
1083: pay_payroll_actions ppa
1084: where ppa.payroll_action_id = pactid
1085: and ppa.report_type = prfm.report_type
1086: and ppa.report_category = prfm.report_category

Line 1161: from pay_report_format_mappings_f prfm,

1157: begin
1158: pactid := l_payroll_action_id;
1159: select prfm.archive_code
1160: into archiv_proc
1161: from pay_report_format_mappings_f prfm,
1162: pay_payroll_actions ppa
1163: where ppa.payroll_action_id = pactid
1164: and ppa.report_type = prfm.report_type
1165: and ppa.report_category = prfm.report_category