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

Line 284: from pay_action_interlocks pai_pre

280:
281:
282: cursor c_check_for_reversal(cp_assignment_action_id in number) is
283: select 1
284: from pay_action_interlocks pai_pre
285: where pai_pre.locking_action_id = cp_assignment_action_id
286: and exists (
287: select 1
288: from pay_payroll_actions ppa,

Line 290: pay_action_interlocks pai_run

286: and exists (
287: select 1
288: from pay_payroll_actions ppa,
289: pay_assignment_actions paa,
290: pay_action_interlocks pai_run
291: /* Get the run assignment action id locked by pre-payment */
292: where pai_run.locked_action_id = pai_pre.locked_action_id
293: /* Check if the Run is being locked by Reversal */
294: and pai_run.locking_action_id = paa.assignment_action_id

Line 306: from pay_action_interlocks paci,

302: ** have been made fro the employee.
303: ****************************************************************/
304: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
305: select paa.assignment_action_id
306: from pay_action_interlocks paci,
307: pay_assignment_actions paa,
308: pay_payroll_actions ppa
309: where paci.locking_action_id = cp_assignment_action_id
310: and paa.assignment_action_id = paci.locked_action_id

Line 323: from pay_action_interlocks pai_run,

319: ** means there is a seperate check.
320: * ***************************************************************/
321: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
322: select paa_pre.assignment_action_id
323: from pay_action_interlocks pai_run,
324: pay_action_interlocks pai_pre,
325: pay_assignment_actions paa_pre,
326: pay_payroll_actions ppa_pre
327: where pai_run.locking_action_id = cp_assignment_action_id

Line 324: pay_action_interlocks pai_pre,

320: * ***************************************************************/
321: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
322: select paa_pre.assignment_action_id
323: from pay_action_interlocks pai_run,
324: pay_action_interlocks pai_pre,
325: pay_assignment_actions paa_pre,
326: pay_payroll_actions ppa_pre
327: where pai_run.locking_action_id = cp_assignment_action_id
328: and pai_pre.locked_action_id = pai_run.locked_action_id

Line 337: ,pay_action_interlocks pai

333: cursor c_get_date_earned(cp_assignment_action_id in number) is
334: select nvl(max(ppa.date_earned), max(ppa.effective_date))
335: from pay_payroll_actions ppa
336: ,pay_assignment_actions paa
337: ,pay_action_interlocks pai
338: where ppa.payroll_action_id = paa.payroll_action_id
339: and pai.locked_action_id = paa.assignment_action_id
340: and pai.locking_action_id = cp_assignment_action_id
341: and ppa.action_type in ('R', 'Q', 'B', 'V');

Line 855: from pay_action_interlocks pai_pre

851:
852:
853: cursor c_check_for_reversal(cp_assignment_action_id in number) is
854: select 1
855: from pay_action_interlocks pai_pre
856: where pai_pre.locking_action_id = cp_assignment_action_id
857: and exists (
858: select 1
859: from pay_payroll_actions ppa,

Line 861: pay_action_interlocks pai_run

857: and exists (
858: select 1
859: from pay_payroll_actions ppa,
860: pay_assignment_actions paa,
861: pay_action_interlocks pai_run
862: /* Get the run assignment action id locked by pre-payment */
863: where pai_run.locked_action_id = pai_pre.locked_action_id
864: /* Check if the Run is being locked by Reversal */
865: and pai_run.locking_action_id = paa.assignment_action_id

Line 877: from pay_action_interlocks paci,

873: ** have been made fro the employee.
874: ****************************************************************/
875: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
876: select paa.assignment_action_id
877: from pay_action_interlocks paci,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa
880: where paci.locking_action_id = cp_assignment_action_id
881: and paa.assignment_action_id = paci.locked_action_id

Line 894: from pay_action_interlocks pai_run,

890: ** means there is a seperate check.
891: * ***************************************************************/
892: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
893: select paa_pre.assignment_action_id
894: from pay_action_interlocks pai_run,
895: pay_action_interlocks pai_pre,
896: pay_assignment_actions paa_pre,
897: pay_payroll_actions ppa_pre
898: where pai_run.locking_action_id = cp_assignment_action_id

Line 895: pay_action_interlocks pai_pre,

891: * ***************************************************************/
892: cursor c_prepay_run_arch_action(cp_assignment_action_id in number) is
893: select paa_pre.assignment_action_id
894: from pay_action_interlocks pai_run,
895: pay_action_interlocks pai_pre,
896: pay_assignment_actions paa_pre,
897: pay_payroll_actions ppa_pre
898: where pai_run.locking_action_id = cp_assignment_action_id
899: and pai_pre.locked_action_id = pai_run.locked_action_id

Line 909: , pay_action_interlocks pai

905: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
906: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
907: FROM pay_payroll_actions ppa
908: , pay_assignment_actions paa
909: , pay_action_interlocks pai
910: WHERE ppa.payroll_action_id = paa.payroll_action_id
911: AND pai.locked_action_id = paa.assignment_action_id
912: AND pai.locking_action_id = cp_assignment_action_id
913: AND ppa.action_type IN ('R', 'Q', 'B', 'V')

Line 935: from pay_action_interlocks ai

931: from pay_assignment_actions paa
932: where paa.assignment_action_id = cp_assignment_action_id
933: and not exists
934: (select 1
935: from pay_action_interlocks ai
936: where ai.locking_action_id = paa.assignment_action_id )
937: and exists
938: (select 1 from pay_assignment_actions paa2,
939: pay_payroll_actions ppa2

Line 1301: ,pay_action_interlocks pai

1297: cursor c_get_date_earned(cp_assignment_action_id in number) is
1298: select nvl(max(ppa.date_earned), max(ppa.effective_date))
1299: from pay_payroll_actions ppa
1300: ,pay_assignment_actions paa
1301: ,pay_action_interlocks pai
1302: where ppa.payroll_action_id = paa.payroll_action_id
1303: and pai.locked_action_id = paa.assignment_action_id
1304: and pai.locking_action_id = cp_assignment_action_id
1305: and ppa.action_type in ('R', 'Q', 'B', 'V');

Line 1714: pay_action_interlocks pai

1710: paa_pymt.serial_number)
1711: from pay_pre_payments ppp,
1712: pay_assignment_actions paa_pymt,
1713: pay_payroll_actions ppa_pymt,
1714: pay_action_interlocks pai
1715: where pai.locked_action_id = cp_pre_payment_action
1716: and paa_pymt.assignment_action_id = pai.locking_action_id
1717: and ppa_pymt.payroll_action_id = paa_pymt.payroll_action_id
1718: and ppa_pymt.action_type in ('M','H', 'E')

Line 1725: pay_action_interlocks pai_void

1721: and not exists (
1722: select 1
1723: from pay_payroll_actions ppa,
1724: pay_assignment_actions paa,
1725: pay_action_interlocks pai_void
1726: /* Assignment Action of Payment Type - NACHA/Check */
1727: where pai_void.locked_action_id = paa_pymt.assignment_action_id --Void
1728: /* Check if the locking is that of Void Pymt */
1729: and pai_void.locking_action_id = paa.assignment_action_id

Line 2609: CURSOR get_locked_act_id (v_action_context_id pay_action_interlocks.locking_action_id%TYPE) IS

2605: assignment_id VARCHAR2(50);
2606: v_effective_date date;
2607: action_information2 VARCHAR2(255);
2608: --
2609: CURSOR get_locked_act_id (v_action_context_id pay_action_interlocks.locking_action_id%TYPE) IS
2610: SELECT
2611: paci.locked_action_id
2612: FROM pay_action_interlocks paci,
2613: pay_assignment_actions paa,

Line 2612: FROM pay_action_interlocks paci,

2608: --
2609: CURSOR get_locked_act_id (v_action_context_id pay_action_interlocks.locking_action_id%TYPE) IS
2610: SELECT
2611: paci.locked_action_id
2612: FROM pay_action_interlocks paci,
2613: pay_assignment_actions paa,
2614: pay_payroll_actions ppa
2615: WHERE paci.locking_action_id = v_action_context_id
2616: AND paa.assignment_action_id = paci.locked_action_id

Line 2914: FROM pay_action_interlocks pai_pre

2910:
2911:
2912: CURSOR c_check_for_reversal(cp_assignment_action_id IN NUMBER) IS
2913: SELECT 1
2914: FROM pay_action_interlocks pai_pre
2915: WHERE pai_pre.locking_action_id = cp_assignment_action_id
2916: AND EXISTS (
2917: SELECT 1
2918: FROM pay_payroll_actions ppa,

Line 2920: pay_action_interlocks pai_run

2916: AND EXISTS (
2917: SELECT 1
2918: FROM pay_payroll_actions ppa,
2919: pay_assignment_actions paa,
2920: pay_action_interlocks pai_run
2921: /* Get the run assignment action id locked by pre-payment */
2922: WHERE pai_run.locked_action_id = pai_pre.locked_action_id
2923: /* Check if the Run is being locked by Reversal */
2924: AND pai_run.locking_action_id = paa.assignment_action_id

Line 2936: FROM pay_action_interlocks paci,

2932: ** have been made fro the employee.
2933: ****************************************************************/
2934: CURSOR c_prepay_arch_action(cp_assignment_action_id IN NUMBER) IS
2935: SELECT paa.assignment_action_id
2936: FROM pay_action_interlocks paci,
2937: pay_assignment_actions paa,
2938: pay_payroll_actions ppa
2939: WHERE paci.locking_action_id = cp_assignment_action_id
2940: AND paa.assignment_action_id = paci.locked_action_id

Line 2953: FROM pay_action_interlocks pai_run,

2949: ** means there is a seperate check.
2950: * ***************************************************************/
2951: CURSOR c_prepay_run_arch_action(cp_assignment_action_id IN NUMBER) IS
2952: SELECT paa_pre.assignment_action_id
2953: FROM pay_action_interlocks pai_run,
2954: pay_action_interlocks pai_pre,
2955: pay_assignment_actions paa_pre,
2956: pay_payroll_actions ppa_pre
2957: WHERE pai_run.locking_action_id = cp_assignment_action_id

Line 2954: pay_action_interlocks pai_pre,

2950: * ***************************************************************/
2951: CURSOR c_prepay_run_arch_action(cp_assignment_action_id IN NUMBER) IS
2952: SELECT paa_pre.assignment_action_id
2953: FROM pay_action_interlocks pai_run,
2954: pay_action_interlocks pai_pre,
2955: pay_assignment_actions paa_pre,
2956: pay_payroll_actions ppa_pre
2957: WHERE pai_run.locking_action_id = cp_assignment_action_id
2958: AND pai_pre.locked_action_id = pai_run.locked_action_id

Line 2968: , pay_action_interlocks pai

2964: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
2965: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
2966: FROM pay_payroll_actions ppa
2967: , pay_assignment_actions paa
2968: , pay_action_interlocks pai
2969: WHERE ppa.payroll_action_id = paa.payroll_action_id
2970: AND pai.locked_action_id = paa.assignment_action_id
2971: AND pai.locking_action_id = cp_assignment_action_id
2972: AND ppa.action_type IN ('R', 'Q', 'B', 'V')