DBA Data[Home] [Help]

APPS.PAY_IE_NES_REPORT_PKG dependencies on FND_LOOKUP_VALUES

Line 594: ,fnd_lookup_values flv

590: ,hla.REGION_1
591: from hr_organization_units hou
592: ,hr_organization_information hoi
593: ,hr_locations_all hla
594: ,fnd_lookup_values flv
595: where hoi.org_information_context='IE_EMPLOYER_INFO'
596: and hoi.organization_id=c_org_id
597: and hoi.organization_id=hou.organization_id
598: and hou.business_group_id= c_bg_id

Line 1316: fnd_lookup_values flv

1312: flv.meaning County,
1313: pa.country Country
1314: from per_addresses pa,
1315: per_all_people_f papf,
1316: fnd_lookup_values flv
1317: where papf.person_id = cp_person_id
1318: and papf.person_id=pa.person_id(+)
1319: and pa.primary_flag (+)= 'Y' --is address primary ?
1320: and pa.date_from(+) <= cp_effective_date