DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on PAY_PAYROLL_ACTIONS

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

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

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

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

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

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

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

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

Line 1088: pay_payroll_actions ppa1, -- Cost pay actions

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