DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_EXT_CROSS_PERSON_RECORDS

Line 1123: FROM pqp_ext_cross_person_records emd

1119: ,p_lea_number VARCHAR2 DEFAULT NULL
1120: ,p_ext_dfn_id NUMBER DEFAULT NULL
1121: ) IS
1122: SELECT *
1123: FROM pqp_ext_cross_person_records emd
1124: WHERE emd.record_type = p_record_type
1125: AND (p_national_identifier IS NULL
1126: OR
1127: (p_national_identifier IS NOT NULL