DBA Data[Home] [Help]

APPS.GML_PO_GLDIST dependencies on GL_EVNT_PLC

Line 40: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m

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'

Line 244: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m

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'

Line 1300: FROM gl_evnt_plc e, gl_srce_mst s, gl_evnt_mst m

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