DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F

Line 674: FROM per_all_assignments_f paf, per_business_groups bsg

670: paf.business_group_id,
671: fnd_number.canonical_to_number (bsg.cost_allocation_structure),
672: paf.effective_start_date,
673: paf.effective_end_date
674: FROM per_all_assignments_f paf, per_business_groups bsg
675: WHERE paf.person_id = p_person_id
676: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date
677: AND paf.assignment_type = 'E'
678: AND paf.primary_flag = 'Y'

Line 1050: FROM PER_ALL_ASSIGNMENTS_F pas,

1046: p_evaluation_date In Date) IS
1047: SELECT pas.BUSINESS_GROUP_ID
1048: , pas.effective_start_date
1049: , pas.effective_end_date
1050: FROM PER_ALL_ASSIGNMENTS_F pas,
1051: per_assignment_status_types typ
1052: WHERE pas.PERSON_ID = p_resource_id
1053: AND pas.ASSIGNMENT_TYPE in ('E','C')
1054: AND pas.PRIMARY_FLAG = 'Y'