APPS.AMS_EVHRULES_PVT dependencies on HZ_PARTIES

Line 1487: -- Assumption : attendant_party_id has party_id from HZ_PARTIES

1483: LOOP
1484: FETCH c_get_registrant_for_lead INTO l_registrant_for_lead_rec;
1485: EXIT WHEN c_get_registrant_for_lead%NOTFOUND;
1486:
1487: -- Assumption : attendant_party_id has party_id from HZ_PARTIES
1488: -- against whom the lead has to be created.
1489: -- This is actually the enrollee and not the person who calls in (the call center) to do the registrations.
1490:
1491:

Line 1536: -- Assumption : registrant_party_id has party_id from HZ_PARTIES

1532: LOOP
1533: FETCH c_get_attendant_for_lead INTO l_attendant_for_lead_rec;
1534: EXIT WHEN c_get_attendant_for_lead%NOTFOUND;
1535:
1536: -- Assumption : registrant_party_id has party_id from HZ_PARTIES
1537: -- against whom the lead has to be created.
1538:
1539: --insert_lead_rec(l_attendant_for_lead_rec.attendant_party_id
1540: -- ,l_lit_batch_id

Line 1678: --Cursor to pick up the data from HZ_PARTIES table.

1674: CURSOR c_rec_id IS --Cursor to pick up the next value in the sequence.
1675: SELECT as_import_interface_s.NEXTVAL
1676: FROM DUAL;
1677:
1678: --Cursor to pick up the data from HZ_PARTIES table.
1679: CURSOR c_party_info (party_id_in IN NUMBER) IS
1680: SELECT party_type
1681: FROM hz_parties
1682: WHERE party_id = party_id_in;

Line 1681: FROM hz_parties

1677:
1678: --Cursor to pick up the data from HZ_PARTIES table.
1679: CURSOR c_party_info (party_id_in IN NUMBER) IS
1680: SELECT party_type
1681: FROM hz_parties
1682: WHERE party_id = party_id_in;
1683:
1684: --Cursor to pick up the data from HZ_PARTIE_SITES table.
1685: CURSOR c_party_site_info (party_id_in IN NUMBER) IS