DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 1022: FROM pay_payroll_actions ppa1, -- Cost pay actions

1018: pcv.debit_or_credit,
1019: decode(pcv.debit_or_credit,'Debit',pcv.costed_value,null) entered_dr,
1020: decode(pcv.debit_or_credit,'Credit',pcv.costed_value,null) entered_cr ,
1021: ppa1.action_type
1022: FROM pay_payroll_actions ppa1, -- Cost pay actions
1023: pay_assignment_actions pa1, -- Cost asg actions.
1024: pay_action_interlocks pi3, -- Cost - Run
1025: pay_action_interlocks pi1, -- Cost - Trans GL
1026: pay_all_payrolls_f pp,

Line 1028: pay_payroll_actions ppa2, -- Payroll run actions.

1024: pay_action_interlocks pi3, -- Cost - Run
1025: pay_action_interlocks pi1, -- Cost - Trans GL
1026: pay_all_payrolls_f pp,
1027: pay_action_classifications pac,
1028: pay_payroll_actions ppa2, -- Payroll run actions.
1029: pay_assignment_actions pa2, -- Payroll run asg actions.
1030: pay_action_interlocks pi2, -- Run - Trans GL
1031: pay_assignment_actions pa, -- Trans GL asg actions
1032: pay_payroll_actions ppa, -- Trans GL pay actions

Line 1032: pay_payroll_actions ppa, -- Trans GL pay actions

1028: pay_payroll_actions ppa2, -- Payroll run actions.
1029: pay_assignment_actions pa2, -- Payroll run asg actions.
1030: pay_action_interlocks pi2, -- Run - Trans GL
1031: pay_assignment_actions pa, -- Trans GL asg actions
1032: pay_payroll_actions ppa, -- Trans GL pay actions
1033: pay_costs_v pcv,
1034: gl_je_headers gjh,
1035: gl_je_lines gjl
1036: WHERE ppa.payroll_action_id = to_number(gjl.reference_1)

Line 1087: FROM pay_payroll_actions ppa, -- Trans GL pay actions

1083: ppc.debit_or_credit,
1084: decode(ppc.debit_or_credit,'Debit',to_number(ppc.costed_value),null) entered_dr,
1085: decode(ppc.debit_or_credit,'Credit',to_number(ppc.costed_value),null) entered_cr,
1086: ppa1.action_type
1087: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1088: pay_assignment_actions pa, -- Trans GL asg actions
1089: pay_action_interlocks pi1, -- Cost - Trans GL
1090: pay_assignment_actions pa1, -- Cost asg actions
1091: pay_payroll_actions ppa1, -- Cost pay actions

Line 1091: pay_payroll_actions ppa1, -- Cost pay actions

1087: FROM pay_payroll_actions ppa, -- Trans GL pay actions
1088: pay_assignment_actions pa, -- Trans GL asg actions
1089: pay_action_interlocks pi1, -- Cost - Trans GL
1090: pay_assignment_actions pa1, -- Cost asg actions
1091: pay_payroll_actions ppa1, -- Cost pay actions
1092: per_all_assignments_f pera,
1093: pay_all_payrolls_f pp,
1094: pay_payment_costs_v ppc,
1095: gl_je_headers gjh,