APPS.PAY_US_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_PAYROLL_ACTIONS

Line 224: from pay_payroll_actions ppa,

220: from pay_action_interlocks pai_pre
221: where pai_pre.locking_action_id = cp_assignment_action_id
222: and exists (
223: select 1
224: from pay_payroll_actions ppa,
225: pay_assignment_actions paa,
226: pay_action_interlocks pai_run
227: /* Get the run assignment action id locked by pre-payment */
228: where pai_run.locked_action_id = pai_pre.locked_action_id

Line 244: pay_payroll_actions ppa

240: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
241: select paa.assignment_action_id
242: from pay_action_interlocks paci,
243: pay_assignment_actions paa,
244: pay_payroll_actions ppa
245: where paci.locking_action_id = cp_assignment_action_id
246: and paa.assignment_action_id = paci.locked_action_id
247: and ppa.payroll_action_id = paa.payroll_action_id
248: and ppa.action_type in ('P', 'U');

Line 262: pay_payroll_actions ppa_pre

258: select paa_pre.assignment_action_id
259: from pay_action_interlocks pai_run,
260: pay_action_interlocks pai_pre,
261: pay_assignment_actions paa_pre,
262: pay_payroll_actions ppa_pre
263: where pai_run.locking_action_id = cp_assignment_action_id
264: and pai_pre.locked_action_id = pai_run.locked_action_id
265: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
266: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 271: from pay_payroll_actions ppa

267: and ppa_pre.action_type in ('P', 'U');
268:
269: cursor c_get_date_earned(cp_assignment_action_id in number) is
270: select nvl(max(ppa.date_earned), max(ppa.effective_date))
271: from pay_payroll_actions ppa
272: ,pay_assignment_actions paa
273: ,pay_action_interlocks pai
274: where ppa.payroll_action_id = paa.payroll_action_id
275: and pai.locked_action_id = paa.assignment_action_id

Line 476: from pay_payroll_actions ppa,

472: from pay_action_interlocks pai_pre
473: where pai_pre.locking_action_id = cp_assignment_action_id
474: and exists (
475: select 1
476: from pay_payroll_actions ppa,
477: pay_assignment_actions paa,
478: pay_action_interlocks pai_run
479: where pai_run.locked_action_id = pai_pre.locked_action_id
480: and pai_run.locking_action_id = paa.assignment_action_id

Line 487: from pay_payroll_actions ppa,

483: and ppa.action_type = 'V');
484: */
485: cursor c_check_for_reversal(cp_assignment_action_id in number) is
486: select 1
487: from pay_payroll_actions ppa,
488: pay_assignment_actions paa,
489: pay_action_interlocks pai_run
490: where pai_run.locked_action_id = cp_assignment_action_id
491: and pai_run.locking_action_id = paa.assignment_action_id

Line 505: pay_payroll_actions ppa

501: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
502: select paa.assignment_action_id
503: from pay_action_interlocks paci,
504: pay_assignment_actions paa,
505: pay_payroll_actions ppa
506: where paci.locking_action_id = cp_assignment_action_id
507: and paa.assignment_action_id = paci.locked_action_id
508: and ppa.payroll_action_id = paa.payroll_action_id
509: and ppa.action_type in ('P', 'U');

Line 523: pay_payroll_actions ppa_pre

519: select paa_pre.assignment_action_id
520: from pay_action_interlocks pai_run,
521: pay_action_interlocks pai_pre,
522: pay_assignment_actions paa_pre,
523: pay_payroll_actions ppa_pre
524: where pai_run.locking_action_id = cp_assignment_action_id
525: and pai_pre.locked_action_id = pai_run.locked_action_id
526: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
527: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 532: from pay_payroll_actions ppa

528: and ppa_pre.action_type in ('P', 'U');
529:
530: cursor c_get_date_earned(cp_assignment_action_id in number) is
531: select nvl(max(ppa.date_earned), max(ppa.effective_date))
532: from pay_payroll_actions ppa
533: ,pay_assignment_actions paa
534: ,pay_action_interlocks pai
535: where ppa.payroll_action_id = paa.payroll_action_id
536: and pai.locked_action_id = paa.assignment_action_id

Line 711: from pay_payroll_actions ppa

707: RETURN VARCHAR2 IS
708:
709: cursor c_get_date_earned(cp_assignment_action_id in number) is
710: select nvl(max(ppa.date_earned), max(ppa.effective_date))
711: from pay_payroll_actions ppa
712: ,pay_assignment_actions paa
713: ,pay_action_interlocks pai
714: where ppa.payroll_action_id = paa.payroll_action_id
715: and pai.locked_action_id = paa.assignment_action_id

Line 803: pay_payroll_actions ppa

799: from pay_run_results prr,
800: pay_run_result_values prrv,
801: pay_input_values_f piv,
802: pay_assignment_actions paa,
803: pay_payroll_actions ppa
804: where prr.element_type_id = piv.element_type_id
805: and prr.run_result_id = prrv.run_result_id
806: and prr.source_type = 'E'
807: and piv.input_value_id = prrv.input_value_id

Line 825: pay_payroll_actions ppa

821: from pay_run_results prr,
822: pay_run_result_values prrv,
823: pay_input_values_f piv,
824: pay_assignment_actions paa,
825: pay_payroll_actions ppa
826: where prr.element_type_id = piv.element_type_id
827: and prr.run_result_id = prrv.run_result_id
828: and prr.source_type = 'E'
829: and piv.input_value_id = prrv.input_value_id

Line 1125: pay_payroll_actions ppa_pymt,

1121: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
1122: paa_pymt.serial_number)
1123: from pay_pre_payments ppp,
1124: pay_assignment_actions paa_pymt,
1125: pay_payroll_actions ppa_pymt,
1126: pay_action_interlocks pai
1127: where pai.locked_action_id = cp_pre_payment_action
1128: and paa_pymt.assignment_action_id = pai.locking_action_id
1129: and ppa_pymt.payroll_action_id = paa_pymt.payroll_action_id

Line 1135: from pay_payroll_actions ppa,

1131: and paa_pymt.pre_payment_id = cp_pre_payment_id
1132: and ppp.pre_payment_id = paa_pymt.pre_payment_id
1133: and not exists (
1134: select 1
1135: from pay_payroll_actions ppa,
1136: pay_assignment_actions paa,
1137: pay_action_interlocks pai_void
1138: /* Assignment Action of Payment Type - NACHA/Check */
1139: where pai_void.locked_action_id = paa_pymt.assignment_action_id --Void