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: --
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: --
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'
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: --
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: --
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: --