APPS.POS_ENTERPRISE_UTIL_PKG dependencies on HZ_PARTIES

Line 13: FROM hz_parties hp, hz_code_assignments hca

9: )
10: IS
11: CURSOR l_cur IS
12: SELECT hp.party_id, hp.party_name
13: FROM hz_parties hp, hz_code_assignments hca
14: WHERE hca.owner_table_id = hp.party_id
15: AND hca.owner_table_name = 'HZ_PARTIES'
16: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
17: AND hca.class_code = 'ENTERPRISE'

Line 15: AND hca.owner_table_name = 'HZ_PARTIES'

11: CURSOR l_cur IS
12: SELECT hp.party_id, hp.party_name
13: FROM hz_parties hp, hz_code_assignments hca
14: WHERE hca.owner_table_id = hp.party_id
15: AND hca.owner_table_name = 'HZ_PARTIES'
16: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
17: AND hca.class_code = 'ENTERPRISE'
18: AND hca.status= 'A'
19: AND hp.status= 'A'

Line 68: l_party_name hz_parties.party_name%TYPE;

64: x_exception_msg OUT NOCOPY VARCHAR2,
65: x_status OUT NOCOPY VARCHAR2
66: )
67: IS
68: l_party_name hz_parties.party_name%TYPE;
69: BEGIN
70: get_enterprise_information(x_party_id, l_party_name, x_exception_msg, x_status);
71: END get_enterprise_partyid;
72:

Line 80: FROM hz_parties hp, hz_code_assignments hca

76: )
77: IS
78: CURSOR l_cur IS
79: SELECT hp.party_id, hp.party_name
80: FROM hz_parties hp, hz_code_assignments hca
81: WHERE hca.owner_table_id = hp.party_id
82: AND hca.owner_table_name = 'HZ_PARTIES'
83: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
84: AND hca.class_code = 'ENTERPRISE'

Line 82: AND hca.owner_table_name = 'HZ_PARTIES'

78: CURSOR l_cur IS
79: SELECT hp.party_id, hp.party_name
80: FROM hz_parties hp, hz_code_assignments hca
81: WHERE hca.owner_table_id = hp.party_id
82: AND hca.owner_table_name = 'HZ_PARTIES'
83: AND hca.class_category = 'POS_PARTICIPANT_TYPE'
84: AND hca.class_code = 'ENTERPRISE'
85: AND hca.status= 'A'
86: AND hp.status= 'A'

Line 90: l_party_name hz_parties.party_name%TYPE;

86: AND hp.status= 'A'
87: AND ( hca.end_date_active > sysdate or hca.end_date_active is null );
88:
89: l_party_id NUMBER;
90: l_party_name hz_parties.party_name%TYPE;
91: l_party_number hz_parties.party_number%TYPE;
92: l_profile_id NUMBER;
93: BEGIN
94: OPEN l_cur;

Line 91: l_party_number hz_parties.party_number%TYPE;

87: AND ( hca.end_date_active > sysdate or hca.end_date_active is null );
88:
89: l_party_id NUMBER;
90: l_party_name hz_parties.party_name%TYPE;
91: l_party_number hz_parties.party_number%TYPE;
92: l_profile_id NUMBER;
93: BEGIN
94: OPEN l_cur;
95: FETCH l_cur INTO l_party_id, l_party_name;

Line 146: l_party_name hz_parties.party_name%TYPE;

142: x_status OUT NOCOPY VARCHAR2
143: )
144: IS
145: l_org_partyId NUMBER;
146: l_party_name hz_parties.party_name%TYPE;
147: l_emp_records NUMBER;
148: l_user_id NUMBER;
149: BEGIN
150: