APPS.PV_PRTNR_PMNT_TYPES_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

  SELECT * FROM TABLE( CAST (pymnt_type_tbl  AS JTF_VARCHAR2_TABLE_200)) order by column_value;

Line: 49

	SELECT payment_type_code, name
	FROM oe_payment_types_vl
	WHERE payment_type_code = 'CREDIT_CARD'
	AND NVL(start_date_active, sysdate) <= sysdate
	AND NVL(end_date_active,sysdate+1) >= sysdate
	AND enabled_flag='Y'
	AND EXISTS(
		SELECT payment_channel_code
		FROM iby_fndcpt_all_pmt_channels_v
		WHERE payment_channel_code = 'CREDIT_CARD'
	);

Line: 65

  l_oe_query_str  := 'SELECT name ||''%''||payment_type_code FROM   oe_payment_types_vl WHERE  payment_type_code IN ( SELECT * FROM TABLE (CAST(:1' ||  'AS JTF_VARCHAR2_TABLE_200)))';

Line: 108

     SELECT geo_hierarchy_id
     FROM PV_PROGRAM_PAYMENT_MODE
     where program_id is null
     and MODE_TYPE='PAYMENT'
     group by geo_hierarchy_id;

Line: 116

  SELECT meaning, lookup_code, mode_of_payment
	from pv_lookups l , PV_PROGRAM_PAYMENT_MODE p
	where	l.lookup_type(+) = 'PV_PAYMENT_TYPE'
		and l.enabled_flag(+) = 'Y'
		and l.lookup_code(+) = p.mode_of_payment
		and NVL(l.start_date_active, SYSDATE) <= SYSDATE
		and NVL(l.end_date_active, SYSDATE) >= SYSDATE
		and p.program_id is null
		and p.geo_hierarchy_id = l_geo_hierarchy_Id
	order by meaning;

Line: 130

    SELECT meaning, lookup_code
    from pv_lookups
    where	lookup_type = 'PV_PAYMENT_TYPE'
		and enabled_flag = 'Y'
		and NVL(start_date_active, SYSDATE) <= SYSDATE
		and NVL(end_date_active, SYSDATE) >= SYSDATE
    order by meaning;