DBA Data[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on PER_BUSINESS_GROUPS

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'