DBA Data[Home] [Help]

APPS.PQH_ASG_WRAPPER dependencies on PQH_COPY_ENTITY_ATTRIBS

Line 108: from pqh_copy_entity_attribs

104: RETURN CHAR IS
105: --
106: Cursor c_get_system_person_type Is
107: Select information22
108: from pqh_copy_entity_attribs
109: Where information22 IS NOT NULL
110: And row_type_cd = 'CRITERIA'
111: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
112: --

Line 225: from pqh_copy_entity_attribs

221: RETURN CHAR IS
222: --
223: Cursor c_get_system_person_type Is
224: Select information22
225: from pqh_copy_entity_attribs
226: Where information22 IS NOT NULL
227: And row_type_cd = 'CRITERIA'
228: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
229: --

Line 344: from pqh_copy_entity_attribs

340: Cursor c_get_criteria_person_type Is
341: Select NVL(check_information1,'N'),
342: NVL(check_information2,'N'),
343: NVL(check_information3,'N')
344: from pqh_copy_entity_attribs
345: Where (check_information1 IS NOT NULL OR
346: check_information2 IS NOT NULL OR
347: check_information3 IS NOT NULL)
348: and row_type_cd = 'CRITERIA'

Line 449: from pqh_copy_entity_attribs

445: RETURN CHAR IS
446: --
447: Cursor c_get_system_person_type Is
448: Select information22
449: from pqh_copy_entity_attribs
450: Where information22 IS NOT NULL
451: And row_type_cd = 'CRITERIA'
452: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
453: --

Line 633: from pqh_copy_entity_attribs

629: --
630: Cursor c_is_field_populated Is
631: Select to_number(information2),
632: to_number(information3)
633: from pqh_copy_entity_attribs
634: Where information2 IS NOT NULL
635: And row_type_cd = 'CRITERIA'
636: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
637: --

Line 950: from pqh_copy_entity_attribs

946: --
947: Cursor c_is_field_populated Is
948: Select to_number(information8),
949: to_number(information9)
950: from pqh_copy_entity_attribs
951: Where information8 IS NOT NULL
952: And row_type_cd = 'CRITERIA'
953: And copy_entity_txn_id = pqh_gen_form.g_txn_id;
954: --