DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 766: per_all_assignments_f paaf,

762: rpaa.assignment_action_id run_assignment_action_id
763: FROM pay_payroll_actions xppa, -- archive pact
764: pay_payroll_actions pppa, -- prepay pact
765: pay_assignment_actions ppaa, -- prepay assact
766: per_all_assignments_f paaf,
767: pay_action_interlocks rpai, -- run interlock by archive assact
768: pay_assignment_actions rpaa, -- run assact
769: pay_payroll_actions rppa -- run pact
770: WHERE xppa.payroll_action_id = cp_payroll_action_id

Line 927: per_all_assignments_f asg

923: from pay_assignment_actions xpaa, -- archive assact
924: pay_action_interlocks rpai, -- run interlock by archive
925: pay_assignment_actions rpaa, -- run assact
926: pay_payroll_actions rppa, -- run pact
927: per_all_assignments_f asg
928: where xpaa.assignment_action_id = p_assignment_action_id
929: and rpai.locking_action_id = xpaa.assignment_action_id
930: and rpaa.assignment_action_id = rpai.locked_action_id
931: and rppa.payroll_action_id = rpaa.payroll_action_id