DBA Data[Home] [Help]

APPS.PAY_KR_PAYKRYLG_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 727: pay_payroll_actions ppa

723: pai.locked_action_id bal_adj_assact
724: from
725: pay_action_interlocks pai,
726: pay_assignment_actions paa,
727: pay_payroll_actions ppa
728: where
729: pai.locking_action_id = p_assignment_action_id
730: and paa.assignment_action_id = pai.locked_action_id
731: and paa.action_status = 'C'

Line 743: from pay_payroll_actions ppa2,

739: is
740: select
741: paa2.assignment_action_id,
742: ppa2.effective_date
743: from pay_payroll_actions ppa2,
744: pay_assignment_actions paa2,
745: pay_payroll_actions ppa,
746: pay_assignment_actions paa
747: where paa.assignment_action_id = p_bal_adj_assact

Line 745: pay_payroll_actions ppa,

741: paa2.assignment_action_id,
742: ppa2.effective_date
743: from pay_payroll_actions ppa2,
744: pay_assignment_actions paa2,
745: pay_payroll_actions ppa,
746: pay_assignment_actions paa
747: where paa.assignment_action_id = p_bal_adj_assact
748: and ppa.payroll_action_id = paa.payroll_action_id
749: and paa2.assignment_id = paa.assignment_id

Line 769: pay_payroll_actions ppa,

765: ppa.effective_date
766: from per_people_f per,
767: per_periods_of_service pds,
768: per_assignments_f asg,
769: pay_payroll_actions ppa,
770: pay_assignment_actions paa
771: where paa.assignment_action_id = p_assignment_action_id
772: and ppa.payroll_action_id = paa.payroll_action_id
773: and asg.assignment_id = paa.assignment_id