DBA Data[Home] [Help]

APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 765: per_all_assignments_f paaf,

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

Line 926: per_all_assignments_f asg

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