[Home] [Help]
36: /* for a particular event code and source_code.*/
37: CURSOR Cur_get_ind_set IS
38: SELECT std_actual_ind , exp_booked_ind ,
39: acquis_cost_ind
40: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m
41: WHERE e.co_code = GML_PO_GLDIST.P_co_code and
42: e.trans_source_type = s.trans_source_type and e.event_type = m.event_type
43: and e.trans_source_type = m.trans_source_type
44: and s.trans_source_code = 'PO' and m.event_code = 'RCPT'
240:
241: CURSOR Cur_get_ind_set IS
242: SELECT std_actual_ind , exp_booked_ind ,
243: acquis_cost_ind
244: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m
245: WHERE e.co_code = GML_PO_GLDIST.P_co_code and
246: e.trans_source_type = s.trans_source_type and e.event_type = m.event_type
247: and e.trans_source_type = m.trans_source_type
248: and s.trans_source_code = 'PO' and m.event_code = 'RCPT'
907: RETURN NUMBER AS
908: CURSOR Cur_get_exch_rate IS
909: SELECT ex.exchange_rate , ex.mul_div_sign,
910: ex.exchange_rate_date
911: FROM gl_xchg_rte ex, gl_srce_mst src
912: WHERE ex.to_currency_code = V_default_currency and
913: ex.from_currency_code= V_billing_currency and
914: ex.exchange_rate_date <= V_po_date and
915: ex.rate_type_code = src.rate_type_code and
918:
919: CURSOR Cur_get_exch_rate_inv IS
920: SELECT ex.exchange_rate , ex.mul_div_sign,
921: ex.exchange_rate_date
922: FROM gl_xchg_rte ex, gl_srce_mst src
923: WHERE ex.to_currency_code = V_billing_currency and
924: ex.from_currency_code= V_default_currency and
925: ex.exchange_rate_date <= V_po_date and
926: ex.rate_type_code = src.rate_type_code and
1296: CURSOR cur_get_srcevtplc IS
1297: SELECT std_actual_ind,
1298: exp_booked_ind,
1299: acquis_cost_ind
1300: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m
1301: WHERE e.co_code = v_co_code
1302: AND e.trans_source_type = s.trans_source_type
1303: AND e.event_type = m.event_type
1304: AND e.trans_source_type = m.trans_source_type