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.

[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_ACTION_INTERLOCKS

Line 693: pay_action_interlocks pai,

689: ,cp_assignment_id in number
690: ,cp_sepchk_run_type in number) is
691: select paa.assignment_action_id
692: from pay_assignment_actions paa,
693: pay_action_interlocks pai,
694: pay_payroll_actions ppa
695: where pai.locking_action_id = cp_prepayment_action_id
696: and paa.assignment_action_id = pai.locked_action_id
697: and paa.assignment_id = cp_assignment_id

Line 716: pay_action_interlocks pai,

712: ,cp_tax_unit_id in number
713: ,cp_sepchk_run_type in number) is
714: select paa.assignment_action_id
715: from pay_assignment_actions paa,
716: pay_action_interlocks pai,
717: pay_payroll_actions ppa
718: where pai.locking_action_id = cp_prepayment_action_id
719: and paa.assignment_action_id = pai.locked_action_id
720: and paa.assignment_id = cp_assignment_id

Line 1135: from pay_action_interlocks pai

1131: and tax_unit_id = cp_tax_unit_id;
1132:
1133: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1134: select paa.assignment_action_id
1135: from pay_action_interlocks pai
1136: ,pay_assignment_actions paa
1137: ,pay_payroll_actions ppa
1138: where pai.locked_action_id = cp_source_action_id
1139: and paa.assignment_action_id = pai.locking_action_id

Line 1150: ,pay_action_interlocks pai

1146: cursor c_run_master_aa_id(cp_pp_asg_act_id number
1147: ,cp_assignment_id number) is
1148: select paa.assignment_action_id,ppa_run.action_type
1149: from pay_assignment_actions paa
1150: ,pay_action_interlocks pai
1151: ,pay_payroll_actions ppa_run
1152: where pai.locking_action_id = cp_pp_asg_act_id
1153: and paa.assignment_action_id = pai.locked_action_id
1154: and paa.assignment_id = cp_assignment_id

Line 1166: pay_action_interlocks pai

1162: ,cp_tax_unit_id in number
1163: ,cp_sepchk_run_type in number) is
1164: select paa.assignment_action_id
1165: from pay_assignment_actions paa,
1166: pay_action_interlocks pai
1167: where pai.locking_action_id = cp_pp_asg_act_id
1168: and paa.assignment_action_id = pai.locked_action_id
1169: and paa.assignment_id = cp_assignment_id
1170: and paa.tax_unit_id = cp_tax_unit_id

Line 1471: from pay_action_interlocks pai

1467: and tax_unit_id = cp_tax_unit_id;
1468:
1469: cursor c_get_pp_actid_of_sepchk(cp_source_action_id number) is
1470: select paa.assignment_action_id
1471: from pay_action_interlocks pai
1472: ,pay_assignment_actions paa
1473: ,pay_payroll_actions ppa
1474: where pai.locked_action_id = cp_source_action_id
1475: and paa.assignment_action_id = pai.locking_action_id

Line 1485: ,pay_action_interlocks pai

1481: ,cp_assignment_id number
1482: ,cp_tax_unit_id number) is
1483: select paa.assignment_action_id, paa.source_action_id
1484: from pay_assignment_actions paa
1485: ,pay_action_interlocks pai
1486: where pai.locking_action_id = cp_pp_asg_act_id
1487: and paa.assignment_action_id = pai.locked_action_id
1488: and paa.assignment_id = cp_assignment_id
1489: and paa.tax_unit_id = cp_tax_unit_id

Line 1499: pay_action_interlocks pai

1495: ,cp_tax_unit_id in number
1496: ,cp_sepchk_run_type in number) is
1497: select paa.assignment_action_id
1498: from pay_assignment_actions paa,
1499: pay_action_interlocks pai
1500: where pai.locking_action_id = cp_pp_asg_act_id
1501: and paa.assignment_action_id = pai.locked_action_id
1502: and paa.assignment_id = cp_assignment_id
1503: and paa.tax_unit_id = cp_tax_unit_id

Line 1963: ,pay_action_interlocks pai

1959:
1960: cursor c_tax_unit(cp_pp_asg_act_id number) is
1961: select distinct paa.tax_unit_id
1962: from pay_assignment_actions paa
1963: ,pay_action_interlocks pai
1964: where pai.locking_action_id = cp_pp_asg_act_id
1965: and paa.assignment_action_id = pai.locked_action_id
1966: and paa.tax_unit_id is not null;
1967:

Line 1971: ,pay_action_interlocks pai

1967:
1968: cursor c_run_aa_id(cp_pp_asg_act_id number) is
1969: select paa.assignment_action_id, paa.source_action_id
1970: from pay_assignment_actions paa
1971: ,pay_action_interlocks pai
1972: where pai.locking_action_id = cp_pp_asg_act_id
1973: and paa.assignment_action_id = pai.locked_action_id
1974: and paa.source_action_id is not null
1975: order by paa.action_sequence desc;

Line 2233: from pay_action_interlocks pai,

2229: cursor c_pre_pay_run_action
2230: (cp_master_prepay_action_id in number
2231: ,cp_sepchk_run_type_id in number) is
2232: select pai.locked_action_id
2233: from pay_action_interlocks pai,
2234: pay_assignment_actions paa
2235: where pai.locking_action_id = cp_master_prepay_action_id
2236: and paa.assignment_action_id = pai.locked_action_id
2237: and paa.source_action_id is not null

Line 2475: from pay_action_interlocks pai,

2471: and prt.legislation_code = 'CA';
2472:
2473: cursor c_assignment_run (cp_prepayment_action_id in number) is
2474: select distinct paa.assignment_id
2475: from pay_action_interlocks pai,
2476: pay_assignment_actions paa,
2477: pay_payroll_actions ppa
2478: where pai.locking_action_id = cp_prepayment_action_id
2479: and paa.assignment_action_id = pai.locked_action_id

Line 2495: pay_action_interlocks pai

2491: select paa.assignment_action_id, paa.payroll_action_id,
2492: ppa.action_type
2493: from pay_payroll_actions ppa,
2494: pay_assignment_actions paa,
2495: pay_action_interlocks pai
2496: where pai.locking_action_Id = cp_prepayment_action_id
2497: and pai.locked_action_id = paa.assignment_action_id
2498: and paa.assignment_id = cp_assignment_id
2499: and paa.source_action_id is null

Line 2521: from pay_action_interlocks

2517: with same effective date, 'B'. Bug#3498653 */
2518:
2519: cursor c_get_emp_adjbal(cp_xfr_action_id number) IS
2520: select locked_action_id
2521: from pay_action_interlocks
2522: where locking_action_id = cp_xfr_action_id;
2523:
2524: /* Added this cursor to get the run action type, so that
2525: if it is reversals 'V' then we will not call the

Line 2535: pay_action_interlocks pai

2531: cp_assignment_id in number) is
2532: select distinct ppa.action_type
2533: from pay_payroll_actions ppa,
2534: pay_assignment_actions paa,
2535: pay_action_interlocks pai
2536: where pai.locking_action_Id = cp_prepayment_action_id
2537: and pai.locked_action_id = paa.assignment_action_id
2538: and paa.assignment_id = cp_assignment_id
2539: and paa.source_action_id is null

Line 3115: from pay_action_interlocks pai,

3111: and paa.action_status = ''C''
3112: and paa.source_action_id is null
3113: and not exists
3114: (select ''x''
3115: from pay_action_interlocks pai,
3116: pay_assignment_actions paa1,
3117: pay_payroll_actions ppa1
3118: where pai.locked_action_id = paa.assignment_action_id
3119: and paa1.assignment_action_id = pai.locking_action_id

Line 3200: from pay_action_interlocks pai1,

3196: 'N') = 'N'
3197: and paa.source_action_id is null
3198: and not exists
3199: (select 'x'
3200: from pay_action_interlocks pai1,
3201: pay_assignment_actions paa1,
3202: pay_payroll_actions ppa1
3203: where pai1.locked_action_id = paa.assignment_action_id
3204: and paa1.assignment_action_id = pai1.locking_action_id

Line 3214: pay_action_interlocks pai

3210: cursor c_master_action(cp_prepayment_action_id number) is
3211: select max(paa.assignment_action_id)
3212: from pay_payroll_actions ppa,
3213: pay_assignment_actions paa,
3214: pay_action_interlocks pai
3215: where pai.locking_action_Id = cp_prepayment_action_id
3216: and pai.locked_action_id = paa.assignment_action_id
3217: and paa.source_action_id is null
3218: and ppa.payroll_action_id = paa.payroll_action_id