APPS.ASO_PUBLISH_MISC_INT dependencies on HZ_PERSON_LANGUAGE

Line 1325: FROM hz_person_language

1321: l_debug VARCHAR2(1);
1322:
1323: Cursor C_Lang1 (l_party_id number) is
1324: SELECT language_use_reference_id, object_version_number
1325: FROM hz_person_language
1326: WHERE party_id=l_party_id and primary_language_indicator='Y';
1327:
1328: Cursor C_Lang2 (l_party_id number, l_language_name varchar2) is
1329: SELECT language_use_reference_id, object_version_number

Line 1330: FROM hz_person_language

1326: WHERE party_id=l_party_id and primary_language_indicator='Y';
1327:
1328: Cursor C_Lang2 (l_party_id number, l_language_name varchar2) is
1329: SELECT language_use_reference_id, object_version_number
1330: FROM hz_person_language
1331: WHERE party_id=l_party_id
1332: AND language_name=l_language_name
1333: AND nvl(status,'A') = 'A';
1334: