DBA Data[Home] [Help]

APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 918: ,per_all_assignments_f asg

914: l_sql :=
915: 'select distinct asg.person_id
916: from
917: pay_payroll_actions ppa
918: ,per_all_assignments_f asg
919: where
920: ppa.payroll_action_id = :payroll_action_id
921: and asg.business_group_id = ppa.business_group_id
922: and (asg.assignment_type = ''E''

Line 932: ,per_all_assignments_f asg

928: l_sql :=
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

Line 981: ,per_all_assignments_f paf

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
985: and paf.period_of_service_id = pos.period_of_service_id

Line 994: per_all_assignments_f paf

990: select distinct
991: paf.assignment_id
992: ,paf.person_id
993: from
994: per_all_assignments_f paf
995: where
996: paf.person_id between p_stperson and p_endperson
997: and paf.business_group_id = p_bgid
998: and (paf.assignment_type = 'E'