DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_BUSINESS_GROUPS

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'