APPS.OKS_COPY_CONTRACT_PVT dependencies on OKS_SUBSCR_HEADER_B

Line 13945: FROM OKS_SUBSCR_HEADER_B

13941: --------------------------------
13942: Function GetSubscriptionFrequency(p_line_id IN NUMBER) RETURN VARCHAR2 IS
13943: CURSOR getFrequency IS
13944: SELECT frequency
13945: FROM OKS_SUBSCR_HEADER_B
13946: WHERE cle_id = p_line_id;
13947:
13948: l_Frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE;
13949:

Line 13948: l_Frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE;

13944: SELECT frequency
13945: FROM OKS_SUBSCR_HEADER_B
13946: WHERE cle_id = p_line_id;
13947:
13948: l_Frequency OKS_SUBSCR_HEADER_B.FREQUENCY%TYPE;
13949:
13950: Begin
13951: OPEN getFrequency;
13952: FETCH getFrequency INTO l_Frequency;

Line 14241: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)

14237: ,decode(okcB.LSE_ID
14238: ,122
14239: ,oksB.USAGE_PERIOD
14240: ,46
14241: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)
14242: ,oksB.PRICE_UOM
14243: )AS PRICE_UOM
14244: -- hkamdar 04-Sep-2006 Added for bug# 5458842.
14245: ,oksB.USAGE_TYPE as USAGE_TYPE

Line 14278: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)

14274: ,decode(okcB.LSE_ID
14275: ,12
14276: ,oksB.USAGE_PERIOD
14277: ,46
14278: ,(SELECT frequency FROM OKS_SUBSCR_HEADER_B WHERE cle_id = okcB.ID)
14279: ,oksB.PRICE_UOM
14280: )AS PRICE_UOM
14281: -- hkamdar 04-Sep-2006 Added for bug# 5458842.
14282: ,oksB.USAGE_TYPE as USAGE_TYPE