APPS.HZ_REGISTRY_VALIDATE_BO_PVT dependencies on HZ_CITIZENSHIP

Line 866: FROM HZ_CITIZENSHIP

862: x_object_version_number OUT NOCOPY NUMBER
863: ) IS
864: CURSOR is_citizen_id_exist(l_citizen_id NUMBER)IS
865: SELECT nvl(object_version_number,1), party_id
866: FROM HZ_CITIZENSHIP
867: WHERE citizenship_id = l_citizen_id
868: AND rownum = 1;
869:
870: CURSOR is_citizenship_exist(l_party_id NUMBER, l_country_code VARCHAR2)IS

Line 872: FROM HZ_CITIZENSHIP

868: AND rownum = 1;
869:
870: CURSOR is_citizenship_exist(l_party_id NUMBER, l_country_code VARCHAR2)IS
871: SELECT nvl(object_version_number,1), citizenship_id
872: FROM HZ_CITIZENSHIP
873: WHERE party_id = l_party_id
874: AND country_code = l_country_code
875: AND status in ('A','I')
876: AND rownum = 1;

Line 2850: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY

2846:
2847: FOR i IN 1..p_bus_object.business_object_code.COUNT LOOP
2848: -- get all entities of person, for person, the possible entites are
2849: -- HZ_PARTY_PREFERENCES, HZ_RELATIONSHIPS, HZ_CODE_ASSIGNMENTS,
2850: -- HZ_PERSON_LANGUAGE, HZ_EDUCATION, HZ_CITIZENSHIP, HZ_EMPLOYMENT_HISTORY
2851: -- HZ_PERSON_INTEREST, HZ_CERTIFICATIONS, HZ_FINANCIAL_PROFILE,
2852: -- HZ_CONTACT_PREFERENCES
2853: IF(p_bus_object.tca_mandated_flag(i) = 'N' AND
2854: p_bus_object.user_mandated_flag(i) = 'Y' AND

Line 2868: WHEN p_bus_object.entity_name(i) = 'HZ_CITIZENSHIP' THEN

2864: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_LANGUAGE' THEN
2865: l_lang := TRUE;
2866: WHEN p_bus_object.entity_name(i) = 'HZ_EDUCATION' THEN
2867: l_edu := TRUE;
2868: WHEN p_bus_object.entity_name(i) = 'HZ_CITIZENSHIP' THEN
2869: l_citiz := TRUE;
2870: WHEN p_bus_object.entity_name(i) = 'HZ_PERSON_INTEREST' THEN
2871: l_int := TRUE;
2872: WHEN p_bus_object.entity_name(i) = 'HZ_CERTIFICATIONS' THEN