DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 1102: FROM pqp_ext_cross_person_records emd

1098: ,p_lea_number VARCHAR2 DEFAULT NULL
1099: ,p_ext_dfn_id NUMBER DEFAULT NULL
1100: ) IS
1101: SELECT *
1102: FROM pqp_ext_cross_person_records emd
1103: WHERE emd.record_type = p_record_type
1104: AND (p_national_identifier IS NULL
1105: OR
1106: (p_national_identifier IS NOT NULL