APPS.PV_PARTNER_CONTRACTS_PVT dependencies on PV_LOOKUPS

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 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

Line 387: from pv_lookups l

383: AND NVL(l.end_date_active, SYSDATE)>=SYSDATE
384: AND l.lookup_code <> 'REJECT'
385: union all
386: SELECT l.lookup_code, l.meaning
387: from pv_lookups l
388: where l.lookup_type = 'PV_CONTRACT_RESPONSE'
389: and l.enabled_flag = 'Y'
390: AND NVL(l.start_date_active, SYSDATE)<=SYSDATE
391: AND NVL(l.end_date_active, SYSDATE)>=SYSDATE

Line 397: from pv_lookups l

393: order by meaning;
394:
395: CURSOR c_get_all_cntr_resp_opt IS
396: SELECT lookup_code, meaning
397: from pv_lookups l
398: where l.lookup_type = 'PV_CONTRACT_RESPONSE'
399: and l.enabled_flag = 'Y'
400: AND NVL(l.start_date_active, SYSDATE)<=SYSDATE
401: AND NVL(l.end_date_active, SYSDATE)>=SYSDATE