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_US_EMP_BALADJ_CLEANUP dependencies on PAY_PAYROLL_ACTIONS

Line 84: from pay_payroll_actions

80: 'TRANSFER_CONSOLIDATION_SET_ID=') - 1 )
81: - (instr(legislative_parameters,
82: 'TRANSFER_PAYROLL_ID=')
83: + length('TRANSFER_PAYROLL_ID='))))))
84: from pay_payroll_actions
85: where payroll_action_id = cp_payroll_action_id;
86:
87: ld_end_date DATE;
88: ld_start_date DATE;

Line 680: pay_payroll_actions ppa

676: lv_sql_string :=
677: 'select distinct paf.person_id
678: from per_assignments_f paf,
679: pay_assignment_actions paa,
680: pay_payroll_actions ppa
681: where ppa.business_group_id = ''' || ln_business_group_id || '''
682: and paf.assignment_id = paa.assignment_id
683: and ppa.effective_date between paf.effective_start_date
684: and paf.effective_end_date

Line 737: pay_payroll_actions ppa

733: paa.assignment_id,
734: ppa.effective_date
735: from per_assignments_f paf,
736: pay_assignment_actions paa,
737: pay_payroll_actions ppa
738: where paf.person_id between cp_start_person_id
739: and cp_end_person_id
740: and ppa.effective_date between paf.effective_start_date
741: and paf.effective_end_date

Line 759: pay_payroll_actions ppa1

755: and not exists
756: (select 1
757: from pay_action_interlocks pai,
758: pay_assignment_actions paa1,
759: pay_payroll_actions ppa1
760: where pai.locked_action_id = paa.assignment_action_id
761: and paa1.assignment_action_id = pai.locking_action_id
762: and ppa1.payroll_action_id = paa1.payroll_action_id
763: and ppa1.action_type = 'V'

Line 783: pay_payroll_actions ppa

779: ppa.effective_date
780: from per_assignments_f paf,
781: pay_us_emp_state_tax_rules_f pest,
782: pay_assignment_actions paa,
783: pay_payroll_actions ppa
784: where paf.person_id between cp_start_person_id
785: and cp_end_person_id
786: and ppa.effective_date between paf.effective_start_date
787: and paf.effective_end_date

Line 809: pay_payroll_actions ppa1

805: and not exists
806: (select 1
807: from pay_action_interlocks pai,
808: pay_assignment_actions paa1,
809: pay_payroll_actions ppa1
810: where pai.locked_action_id = paa.assignment_action_id
811: and paa1.assignment_action_id = pai.locking_action_id
812: and ppa1.payroll_action_id = paa1.payroll_action_id
813: and ppa1.action_type = 'V'

Line 828: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

824:
825: cursor c_get_latest_action(cp_assignment_id number
826: ,cp_tax_unit_id number) is
827: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
828: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
829: paa.assignment_action_id, ppa.effective_date,
830: ppa.payroll_id, ppa.consolidation_set_id
831: from pay_assignment_actions paa,
832: pay_payroll_actions ppa

Line 832: pay_payroll_actions ppa

828: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
829: paa.assignment_action_id, ppa.effective_date,
830: ppa.payroll_id, ppa.consolidation_set_id
831: from pay_assignment_actions paa,
832: pay_payroll_actions ppa
833: where paa.assignment_id = cp_assignment_id
834: and paa.tax_unit_id = cp_tax_unit_id
835: and paa.payroll_action_id = ppa.payroll_action_id
836: and ppa.action_type in ('R', 'Q', 'B', 'I', 'V')

Line 1262: pay_payroll_actions ppa

1258:
1259: cursor c_get_chunk_date(cp_payroll_action_id in number) is
1260: select min(paa.chunk_number)
1261: from pay_assignment_actions paa,
1262: pay_payroll_actions ppa
1263: where ppa.payroll_action_id = paa.payroll_Action_id
1264: and ppa.payroll_action_id = cp_payroll_action_id;
1265:
1266: BEGIN

Line 1401: from pay_payroll_actions ppa

1397: where paa.assignment_action_id = cp_assignment_action_id;
1398:
1399: cursor get_asg_run_info(cp_run_action_id in number) is
1400: select payroll_id, consolidation_set_id
1401: from pay_payroll_actions ppa
1402: ,pay_assignment_actions paa
1403: where ppa.payroll_Action_id = paa.payroll_action_id
1404: and paa.assignment_action_id = cp_run_action_id;
1405:

Line 1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */

1428:
1429: cursor c_get_per_latest_action(cp_assignment_id number
1430: ,cp_tax_unit_id number) is
1431: select /*+ INDEX(paa PAY_ASSIGNMENT_ACTIONS_N51)
1432: INDEX(ppa PAY_PAYROLL_ACTIONS_PK) */
1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,
1436: per_all_assignments_f paf1,

Line 1437: pay_payroll_actions ppa

1433: paa.assignment_action_id
1434: from pay_assignment_actions paa,
1435: per_all_assignments_f paf,
1436: per_all_assignments_f paf1,
1437: pay_payroll_actions ppa
1438: where paf1.assignment_id = cp_assignment_id
1439: and paf.person_id = paf1.person_id
1440: and paa.assignment_id = paf.assignment_id
1441: and paa.tax_unit_id = cp_tax_unit_id