DBA Data[Home] [Help]

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)