APPS.PNP_UTIL_FUNC dependencies on AP_DISTRIBUTION_SETS

Line 5748: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ap_distribution_sets

5744: -- RETURNS : Distribution Name
5745: -- REFERENCE :
5746: -- HISTORY :
5747: -- 23-MAY-01 Mrinal Misra o Created
5748: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ap_distribution_sets
5749: -- with _ALL table.
5750: +===========================================================================*/
5751:
5752: FUNCTION Get_Distribution_Set_Name (p_dist_set_id IN NUMBER)

Line 5756: l_dist_set_name ap_distribution_sets.distribution_set_name%type;

5752: FUNCTION Get_Distribution_Set_Name (p_dist_set_id IN NUMBER)
5753:
5754: RETURN VARCHAR2 IS
5755:
5756: l_dist_set_name ap_distribution_sets.distribution_set_name%type;
5757:
5758: BEGIN
5759:
5760: SELECT distribution_set_name

Line 5762: FROM ap_distribution_sets_all

5758: BEGIN
5759:
5760: SELECT distribution_set_name
5761: INTO l_dist_set_name
5762: FROM ap_distribution_sets_all
5763: WHERE distribution_set_id = p_dist_set_id;
5764:
5765: RETURN(l_dist_set_name);
5766: