DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 669: FROM per_all_assignments_f paf, per_business_groups bsg

665: paf.business_group_id,
666: fnd_number.canonical_to_number (bsg.cost_allocation_structure),
667: paf.effective_start_date,
668: paf.effective_end_date
669: FROM per_all_assignments_f paf, per_business_groups bsg
670: WHERE paf.person_id = p_person_id
671: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
672: AND paf.assignment_type = 'E'
673: AND paf.primary_flag = 'Y'

Line 1024: FROM PER_ALL_ASSIGNMENTS_F pas,

1020: p_evaluation_date In Date) IS
1021: SELECT pas.BUSINESS_GROUP_ID
1022: , pas.effective_start_date
1023: , pas.effective_end_date
1024: FROM PER_ALL_ASSIGNMENTS_F pas,
1025: per_assignment_status_types typ
1026: WHERE pas.PERSON_ID = p_resource_id
1027: AND pas.ASSIGNMENT_TYPE in ('E','C')
1028: AND pas.PRIMARY_FLAG = 'Y'