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

Line 1267: pay_action_interlocks pai_sal,

1263: select /*+ ORDERED */
1264: paa_yea.assignment_action_id
1265: from pay_assignment_actions paa_sal,
1266: pay_payroll_actions ppa_sal,
1267: pay_action_interlocks pai_sal,
1268: pay_pre_payments ppp_pp,
1269: pay_assignment_actions paa_pp,
1270: pay_payroll_actions ppa_pp,
1271: pay_action_interlocks pai_yea,

Line 1271: pay_action_interlocks pai_yea,

1267: pay_action_interlocks pai_sal,
1268: pay_pre_payments ppp_pp,
1269: pay_assignment_actions paa_pp,
1270: pay_payroll_actions ppa_pp,
1271: pay_action_interlocks pai_yea,
1272: pay_assignment_actions paa_yea,
1273: pay_payroll_actions ppa_yea
1274: where paa_sal.assignment_action_id = p_assignment_action_id
1275: and ppa_sal.payroll_action_id = paa_sal.payroll_action_id

Line 1300: from pay_action_interlocks pai_v,

1296: and decode(nvl(ppa_yea.element_type_id,-1),-1,decode(nvl(ppa_yea.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa_yea.assignment_action_id,ppa_yea.action_type),'X'),'YEA'),'YEA') = 'YEA'
1297: and not exists(
1298: select /*+ ORDERED */
1299: null
1300: from pay_action_interlocks pai_v,
1301: pay_assignment_actions paa_v,
1302: pay_payroll_actions ppa_v
1303: where pai_v.locked_action_id = paa_yea.assignment_action_id
1304: and paa_v.assignment_action_id = pai_v.locking_action_id

Line 1477: pay_action_interlocks pai_bon,

1473: select /*+ ORDERED */
1474: paa_yea.assignment_action_id
1475: from pay_assignment_actions paa_bon,
1476: pay_payroll_actions ppa_bon,
1477: pay_action_interlocks pai_bon,
1478: pay_pre_payments ppp_pp,
1479: pay_assignment_actions paa_pp,
1480: pay_payroll_actions ppa_pp,
1481: pay_action_interlocks pai_yea,

Line 1481: pay_action_interlocks pai_yea,

1477: pay_action_interlocks pai_bon,
1478: pay_pre_payments ppp_pp,
1479: pay_assignment_actions paa_pp,
1480: pay_payroll_actions ppa_pp,
1481: pay_action_interlocks pai_yea,
1482: pay_assignment_actions paa_yea,
1483: pay_payroll_actions ppa_yea
1484: where paa_bon.assignment_action_id = p_assignment_action_id
1485: and ppa_bon.payroll_action_id = paa_bon.payroll_action_id

Line 1513: from pay_action_interlocks pai_v,

1509: and decode(nvl(ppa_yea.element_type_id,-1),-1,decode(nvl(ppa_yea.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa_yea.assignment_action_id,ppa_yea.action_type),'X'),'YEA'),'YEA') = 'YEA'
1510: and not exists(
1511: select /*+ ORDERED */
1512: null
1513: from pay_action_interlocks pai_v,
1514: pay_assignment_actions paa_v,
1515: pay_payroll_actions ppa_v
1516: where pai_v.locked_action_id = paa_yea.assignment_action_id
1517: and paa_v.assignment_action_id = pai_v.locking_action_id

Line 1523: from pay_action_interlocks pai_sal,

1519: and ppa_v.action_type = 'V')
1520: and not exists(
1521: select /*+ ORDERED */
1522: null
1523: from pay_action_interlocks pai_sal,
1524: pay_assignment_actions paa_sal,
1525: pay_payroll_actions ppa_sal
1526: where pai_sal.locking_action_id = ppp_pp.assignment_action_id
1527: and paa_sal.assignment_action_id = pai_sal.locked_action_id

Line 6130: from pay_action_interlocks pai,

6126: between pa.effective_start_date and pa.effective_end_date
6127: and not exists(
6128: select /*+ ORDERED */
6129: null
6130: from pay_action_interlocks pai,
6131: pay_assignment_actions paav,
6132: pay_payroll_actions ppav
6133: where pai.locked_action_id = paa.assignment_action_id
6134: and paav.assignment_action_id = pai.locking_action_id

Line 6198: from pay_action_interlocks pai2,

6194: and paa2.action_status = 'C'
6195: and not exists(
6196: select /*+ ORDERED */
6197: null
6198: from pay_action_interlocks pai2,
6199: pay_assignment_actions paav2,
6200: pay_payroll_actions ppav2
6201: where pai2.locked_action_id = paa2.assignment_action_id
6202: and paav2.assignment_action_id = pai2.locking_action_id

Line 6277: from pay_action_interlocks pai,

6273: and paa.action_status = 'C'
6274: and not exists(
6275: select /*+ ORDERED */
6276: null
6277: from pay_action_interlocks pai,
6278: pay_assignment_actions paav,
6279: pay_payroll_actions ppav
6280: where pai.locked_action_id = paa.assignment_action_id
6281: and paav.assignment_action_id = pai.locking_action_id

Line 6348: from pay_action_interlocks pai2,

6344: and paa2.action_status = 'C'
6345: and not exists(
6346: select /*+ ORDERED */
6347: null
6348: from pay_action_interlocks pai2,
6349: pay_assignment_actions paav2,
6350: pay_payroll_actions ppav2
6351: where pai2.locked_action_id = paa2.assignment_action_id
6352: and paav2.assignment_action_id = pai2.locking_action_id

Line 6450: from pay_action_interlocks pai,

6446: and paa.action_status = 'C'
6447: and not exists(
6448: select /*+ ORDERED */
6449: null
6450: from pay_action_interlocks pai,
6451: pay_assignment_actions paav,
6452: pay_payroll_actions ppav
6453: where pai.locked_action_id = paa.assignment_action_id
6454: and paav.assignment_action_id = pai.locking_action_id

Line 6523: from pay_action_interlocks pai2,

6519: and paa2.action_status = 'C'
6520: and not exists(
6521: select /*+ ORDERED */
6522: null
6523: from pay_action_interlocks pai2,
6524: pay_assignment_actions paav2,
6525: pay_payroll_actions ppav2
6526: where pai2.locked_action_id = paa2.assignment_action_id
6527: and paav2.assignment_action_id = pai2.locking_action_id

Line 6624: from pay_action_interlocks pai,

6620: and paa.action_status = 'C'
6621: and not exists(
6622: select /*+ ORDERED */
6623: null
6624: from pay_action_interlocks pai,
6625: pay_assignment_actions paav,
6626: pay_payroll_actions ppav
6627: where pai.locked_action_id = paa.assignment_action_id
6628: and paav.assignment_action_id = pai.locking_action_id

Line 6697: from pay_action_interlocks pai2,

6693: and paa2.action_status = 'C'
6694: and not exists(
6695: select /*+ ORDERED */
6696: null
6697: from pay_action_interlocks pai2,
6698: pay_assignment_actions paav2,
6699: pay_payroll_actions ppav2
6700: where pai2.locked_action_id = paa2.assignment_action_id
6701: and paav2.assignment_action_id = pai2.locking_action_id

Line 7523: from pay_action_interlocks pai,

7519: and decode(nvl(ppa.element_type_id,-1),-1,decode(nvl(ppa.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id,ppa.action_type),'N'),'Y'),'Y') <> 'N'
7520: and not exists(
7521: select /*+ ORDERED */
7522: null
7523: from pay_action_interlocks pai,
7524: pay_assignment_actions paav,
7525: pay_payroll_actions ppav
7526: where pai.locked_action_id = paa.assignment_action_id
7527: and paav.assignment_action_id = pai.locking_action_id

Line 7584: -- from pay_action_interlocks pai2,

7580: -- and paa2.action_status = 'C'
7581: -- and not exists(
7582: -- select /*+ ORDERED */
7583: -- null
7584: -- from pay_action_interlocks pai2,
7585: -- pay_assignment_actions paav2,
7586: -- pay_payroll_actions ppav2
7587: -- where pai2.locked_action_id = paa2.assignment_action_id
7588: -- and paav2.assignment_action_id = pai2.locking_action_id

Line 7762: from pay_action_interlocks pai,

7758: and decode(nvl(ppa.element_type_id,-1),-1,decode(nvl(ppa.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id,ppa.action_type),'N'),'Y'),'Y') <> 'N'
7759: and not exists(
7760: select /*+ ORDERED */
7761: null
7762: from pay_action_interlocks pai,
7763: pay_assignment_actions paav,
7764: pay_payroll_actions ppav
7765: where pai.locked_action_id = paa.assignment_action_id
7766: and paav.assignment_action_id = pai.locking_action_id

Line 7823: -- from pay_action_interlocks pai2,

7819: -- and decode(nvl(ppa2.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa2.assignment_action_id,ppa2.action_type),'N'),'SAL') = 'SAL'
7820: -- and not exists(
7821: -- select /*+ ORDERED */
7822: -- null
7823: -- from pay_action_interlocks pai2,
7824: -- pay_assignment_actions paav2,
7825: -- pay_payroll_actions ppav2
7826: -- where pai2.locked_action_id = paa2.assignment_action_id
7827: -- and paav2.assignment_action_id = pai2.locking_action_id

Line 8036: from pay_action_interlocks pai,

8032: and decode(nvl(ppa.element_type_id,-1),-1,decode(nvl(ppa.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa.assignment_action_id,ppa.action_type),'N'),'Y'),'Y') <> 'N'
8033: and not exists(
8034: select /*+ ORDERED */
8035: null
8036: from pay_action_interlocks pai,
8037: pay_assignment_actions paav,
8038: pay_payroll_actions ppav
8039: where pai.locked_action_id = paa.assignment_action_id
8040: and paav.assignment_action_id = pai.locking_action_id

Line 8097: -- from pay_action_interlocks pai2,

8093: -- and decode(nvl(ppa2.element_set_id,-1),-1,nvl(pay_jp_itwb_archive_pkg.get_fuzzy_proc_type(paa2.assignment_action_id,ppa2.action_type),'N'),'SAL') = 'SAL'
8094: -- and not exists(
8095: -- select /*+ ORDERED */
8096: -- null
8097: -- from pay_action_interlocks pai2,
8098: -- pay_assignment_actions paav2,
8099: -- pay_payroll_actions ppav2
8100: -- where pai2.locked_action_id = paa2.assignment_action_id
8101: -- and paav2.assignment_action_id = pai2.locking_action_id