APPS.PV_PARTNER_CONTRACTS_PVT dependencies on PV_PROGRAM_PAYMENT_MODE

Line 69: from PV_PROGRAM_PAYMENT_MODE pm, PV_LOOKUPS lk

65: l_str varchar2(2000) default null;
66: l_sep varchar2(2) default null;
67: begin
68: for x in ( select MEANING
69: from PV_PROGRAM_PAYMENT_MODE pm, PV_LOOKUPS lk
70: where pm.GEO_HIERARCHY_ID = p_geo_hierarchy_id
71: and pm.MODE_TYPE = 'CONTRACT'
72: and lk.lookup_type = 'PV_CONTRACT_RESPONSE'
73: and lk.lookup_code = pm.mode_of_payment

Line 368: FROM PV_PROGRAM_PAYMENT_MODE

364:
365:
366: CURSOR c_cntr_geo_hierarchy_ids IS
367: SELECT geo_hierarchy_id
368: FROM PV_PROGRAM_PAYMENT_MODE
369: where program_id is null
370: and MODE_TYPE = 'CONTRACT'
371: group by geo_hierarchy_id;
372:

Line 375: from pv_lookups l, PV_PROGRAM_PAYMENT_MODE p

371: group by geo_hierarchy_id;
372:
373: CURSOR c_get_cntr_resp_opt(l_geo_hierarchy_Id NUMBER) IS
374: SELECT l.lookup_code, l.meaning
375: from pv_lookups l, PV_PROGRAM_PAYMENT_MODE p
376: where l.lookup_code = p.mode_of_payment
377: and l.lookup_type = 'PV_CONTRACT_RESPONSE'
378: and l.enabled_flag = 'Y'
379: and p.program_id is null