APPS.PQH_CORPS_EXTRA_INFO_API dependencies on PQH_CORPS_DEFINITIONS
Line 270: FROM pqh_corps_definitions cpd,
266: CURSOR csr_prim_field_for_corps IS
267: SELECT 'Y'
268: FROM dual
269: WHERE EXISTS (SELECT 1 270: FROM pqh_corps_definitions cpd, 271: pqh_corps_extra_info cei
272: WHERE cei.information_type = 'FILERE'
273: AND cei.corps_definition_id = cpd.corps_definition_id
274: AND fnd_number.canonical_to_number(nvl(cei.information4,'-1')) = nvl(primary_prof_field_id,-1)