DBA Data[Home] [Help]

APPS.PAY_FR_MAP_CALC dependencies on PER_CONTACT_RELATIONSHIPS_V2

Line 139: FROM per_contact_relationships_v2 pcr

135:
136: CURSOR c_no_dep_Child
137: IS
138: SELECT count(*)
139: FROM per_contact_relationships_v2 pcr
140: WHERE pcr.person_id = p_person_id
141: AND dependent_flag = 'Y'
142: AND p_effective_date
143: BETWEEN