eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_ARCHIVE dependencies on PAY_PAYROLL_ACTIONS

Line 108: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

104: l_assignment_dbis archive_items;
105: ------------------------------------------------------------------------
106: l_jur_set varchar_60_tbl;
107: l_jur1_set varchar_60_tbl;
108: l_payroll_action_id pay_payroll_actions.payroll_action_id%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;

Line 109: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

105: ------------------------------------------------------------------------
106: l_jur_set varchar_60_tbl;
107: l_jur1_set varchar_60_tbl;
108: l_payroll_action_id pay_payroll_actions.payroll_action_id%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;

Line 111: l_effective_date pay_payroll_actions.effective_date%TYPE;

107: l_jur1_set varchar_60_tbl;
108: l_payroll_action_id pay_payroll_actions.payroll_action_id%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;

Line 112: l_date_earned pay_payroll_actions.date_earned%TYPE;

108: l_payroll_action_id pay_payroll_actions.payroll_action_id%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;

Line 115: legislative_parameters pay_payroll_actions.legislative_parameters%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: -----------------------------------------------------------------------
119: -- PROCEDURES

Line 471: FROM pay_payroll_actions pa,

467: l_legislation_code,
468: l_effective_date,
469: l_date_earned,
470: legislative_parameters
471: FROM pay_payroll_actions pa,
472: per_business_groups bg
473: WHERE pa.payroll_action_id = l_payroll_action_id AND
474: pa.business_group_id = bg.business_group_id;
475: --

Line 483: pay_payroll_actions pac

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
487: AND pac.payroll_action_id = l_payroll_action_id

Line 504: pay_payroll_actions ppa

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
508: and ppa.effective_date between prfm.effective_start_date

Line 596: pay_payroll_actions ppa

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
600: and ppa.effective_date between prfm.effective_start_date

Line 1083: pay_payroll_actions ppa

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
1087: and ppa.effective_date between prfm.effective_start_date

Line 1162: pay_payroll_actions ppa

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
1166: and ppa.effective_date between prfm.effective_start_date

Line 1355: delete from pay_payroll_actions

1351: --
1352: delete from pay_population_ranges
1353: where payroll_action_id = p_pact_id;
1354: --
1355: delete from pay_payroll_actions
1356: where payroll_action_id = p_pact_id;
1357: else
1358: --
1359: open asgrescur(p_pact_id, p_chunk_no);

Line 1398: from pay_payroll_actions pa1

1394: --
1395: select pay_core_utils.get_parameter('REMOVE_ACT',
1396: pa1.legislative_parameters)
1397: into remove_act
1398: from pay_payroll_actions pa1
1399: where pa1.payroll_action_id = pactid;
1400: --
1401: if (remove_act is null or remove_act = 'Y') then
1402: pay_archive.remove_report_actions(pactid);