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_IE_CESS_REPORT dependencies on PAY_ACTION_INTERLOCKS

Line 146: pay_action_interlocks pai

142: where ppos.person_id = p_person_id
143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
144: from per_all_assignments_f paf,
145: pay_assignment_actions paa,
146: pay_action_interlocks pai
147: where pai.locking_action_id = p_action_context_id
148: and pai.locked_action_id = paa.assignment_action_id
149: and paa.action_status = 'C'
150: and paa.assignment_id = paf.assignment_id

Line 184: pay_action_interlocks pai,

180:
181: cursor cur_supp_run is
182: select fnd_date.canonical_to_date(act_inf.action_information3)
183: from pay_assignment_actions paa_run,
184: pay_action_interlocks pai,
185: pay_assignment_actions paa,
186: pay_payroll_actions ppa,
187: pay_action_information act_inf
188: where ppa.payroll_action_id = paa.payroll_action_id

Line 1600: pay_action_interlocks pai,

1596: FROM --per_periods_of_service ppos,
1597: per_all_assignments_f as1,
1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,
1601: pay_assignment_actions act1,
1602: pay_payroll_actions appa2
1603: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
1604: act.tax_unit_id = p_paye_ref

Line 1670: pay_action_interlocks pai, --bug 4208273

1666: -- refer bug 5233518 for more details.
1667: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
1668: from pay_assignment_actions act3,
1669: pay_payroll_actions appa3,
1670: pay_action_interlocks pai, --bug 4208273
1671: pay_assignment_actions act2, --bug 4208273
1672: pay_payroll_actions appa4 --bug 4208273
1673: where pai.locked_action_id= act3.assignment_action_id
1674: and pai.locking_action_id=act2.assignment_action_id

Line 2024: FROM pay_action_interlocks pre,

2020: paa.effective_date effective_date,
2021: ppaa.effective_date pre_effective_date,
2022: paa.date_earned date_earned,
2023: ptp.time_period_id time_period_id
2024: FROM pay_action_interlocks pre,
2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,

Line 2025: pay_action_interlocks pay,

2021: ppaa.effective_date pre_effective_date,
2022: paa.date_earned date_earned,
2023: ptp.time_period_id time_period_id
2024: FROM pay_action_interlocks pre,
2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,
2029: pay_assignment_actions passact,