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

Line 1239: from pay_action_interlocks pail,

1235: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
1236: )
1237: and not exists
1238: (select distinct paat.assignment_id
1239: from pay_action_interlocks pail,
1240: pay_assignment_actions paat,
1241: pay_payroll_actions paas
1242: where paat.assignment_id = a.assignment_id
1243: and paas.action_type ='X'

Line 1334: from pay_action_interlocks pail,

1330: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
1331: )
1332: and not exists
1333: (select distinct paat.assignment_id
1334: from pay_action_interlocks pail,
1335: pay_assignment_actions paat,
1336: pay_payroll_actions paas
1337: where paat.assignment_id = a.assignment_id
1338: and paas.action_type ='X'

Line 1442: FROM pay_action_interlocks pail,

1438: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
1439: )
1440: AND NOT EXISTS
1441: (SELECT paat.assignment_id
1442: FROM pay_action_interlocks pail,
1443: pay_assignment_actions paat,
1444: pay_payroll_actions paas
1445: WHERE paat.assignment_id = a.assignment_id
1446: AND paas.action_type ='X'

Line 1581: FROM pay_action_interlocks pail,

1577: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
1578: )
1579: AND NOT EXISTS
1580: (SELECT paat.assignment_id
1581: FROM pay_action_interlocks pail,
1582: pay_assignment_actions paat,
1583: pay_payroll_actions paas
1584: WHERE paat.assignment_id = a.assignment_id
1585: AND paas.action_type ='X'

Line 1678: from pay_action_interlocks pail,

1674: and rppa.effective_date between paaf.effective_start_date and paaf.effective_end_date /*Bug 3815301 */
1675: )
1676: and not exists
1677: (select distinct paat.assignment_id
1678: from pay_action_interlocks pail,
1679: pay_assignment_actions paat,
1680: pay_payroll_actions paas
1681: where paat.assignment_id = a.assignment_id
1682: and paas.action_type ='X'

Line 4479: from pay_action_interlocks pai

4475: c_payroll_action_id pay_payroll_actions.payroll_action_id%type,
4476: c_year_start date,
4477: c_year_end date )
4478: is select to_char(pppa.effective_date,'DDMMYYYY')
4479: from pay_action_interlocks pai
4480: ,pay_assignment_actions pac
4481: ,pay_payroll_actions ppa
4482: ,pay_assignment_actions ppac
4483: ,pay_payroll_actions pppa

Line 6024: from pay_action_interlocks pai

6020: cursor etp_prepayment
6021: (c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
6022: c_payroll_action_id pay_payroll_actions.payroll_action_id%type) is
6023: select to_char(pppa.effective_date,'DDMMYYYY')
6024: from pay_action_interlocks pai
6025: ,pay_assignment_actions pac
6026: ,pay_payroll_actions ppa
6027: ,pay_assignment_actions ppac
6028: ,pay_payroll_actions pppa