DBA Data[Home] [Help]

APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 933: ,per_periods_of_service pos

929: 'select distinct asg.person_id
930: from
931: pay_payroll_actions ppa
932: ,per_all_assignments_f asg
933: ,per_periods_of_service pos
934: where
935: ppa.payroll_action_id = :payroll_action_id
936: and asg.business_group_id = ppa.business_group_id
937: and pos.person_id = asg.person_id

Line 980: per_periods_of_service pos

976: select distinct
977: paf.assignment_id
978: ,paf.person_id
979: from
980: per_periods_of_service pos
981: ,per_all_assignments_f paf
982: where
983: pos.person_id between p_stperson and p_endperson
984: and pos.business_group_id = p_bgid