APPS.AS_SALES_LEAD_RANKS_PUB dependencies on AS_SALES_LEAD_RANKS_B

Line 5: -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL

1: PACKAGE BODY AS_SALES_LEAD_RANKS_PUB AS
2: /* #$Header: asxprnkb.pls 120.0 2005/06/09 17:39:49 appldev noship $ */
3: -- Start of Comments
4: -- Package name : AS_SALES_LEAD_RANKS_PUB
5: -- Purpose : to add ranks into AS_SALES_LEAD_RANKS_B and _TL
6: -- History : 07/24/2000 raverma created
7: -- NOTE :
8: -- End of Comments
9:

Line 47: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B

43: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
44: l_rank_id NUMBER;
45: l_dummy CHAR(1);
46:
47: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
48: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
49:
50: BEGIN
51: -- Standard start of API savepoint

Line 128: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B

124: l_msg_data VARCHAR2(32767);
125: l_sales_lead_rank_rec AS_SALES_LEAD_RANKS_PUB.sales_lead_rank_rec_type;
126: l_dummy CHAR(1);
127:
128: CURSOR c1 IS SELECT 'X' FROM AS_SALES_LEAD_RANKS_B
129: WHERE rank_id = p_sales_lead_rank_rec.RANK_ID;
130:
131: BEGIN
132: -- Standard start of API savepoint