APPS.PNP_UTIL_FUNC dependencies on AP_DISTRIBUTION_SETS

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

5586: -- RETURNS : Distribution Name
5587: -- REFERENCE :
5588: -- HISTORY :
5589: -- 23-MAY-01 Mrinal Misra o Created
5590: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced ap_distribution_sets
5591: -- with _ALL table.
5592: +===========================================================================*/
5593:
5594: FUNCTION Get_Distribution_Set_Name (p_dist_set_id IN NUMBER)

Line 5598: l_dist_set_name ap_distribution_sets.distribution_set_name%type;

5594: FUNCTION Get_Distribution_Set_Name (p_dist_set_id IN NUMBER)
5595:
5596: RETURN VARCHAR2 IS
5597:
5598: l_dist_set_name ap_distribution_sets.distribution_set_name%type;
5599:
5600: BEGIN
5601:
5602: SELECT distribution_set_name

Line 5604: FROM ap_distribution_sets_all

5600: BEGIN
5601:
5602: SELECT distribution_set_name
5603: INTO l_dist_set_name
5604: FROM ap_distribution_sets_all
5605: WHERE distribution_set_id = p_dist_set_id;
5606:
5607: RETURN(l_dist_set_name);
5608: