DBA Data[Home] [Help]

APPS.GML_ACCT_GENERATE dependencies on GL_PLCY_MST

Line 232: from sy_orgn_mst orgn, gl_plcy_mst plcy

228: whse.orgn_code = mst.orgn_code ;
229:
230: Cursor cur_base_curr is
231: Select plcy.base_currency_code
232: from sy_orgn_mst orgn, gl_plcy_mst plcy
233: where orgn.orgn_code = x_whse_orgn_code and orgn.co_code = plcy.co_code;
234:
235: Cursor cur_opm_vend is
236: Select vendor_id, vendgl_class from po_vend_mst

Line 613: x_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;

609: x_validation_date DATE;
610: x_segment_count NUMBER;
611: x_of_seg fnd_flex_ext.SegmentArray;
612: x_ret BOOLEAN;
613: x_segment_delimiter gl_plcy_mst.segment_delimiter%TYPE;
614:
615:
616: Cursor get_chart_id is
617: select chart_of_accounts_id

Line 618: from gl_plcy_mst,gl_sets_of_books

614:
615:
616: Cursor get_chart_id is
617: select chart_of_accounts_id
618: from gl_plcy_mst,gl_sets_of_books
619: where co_code = v_co_code
620: and name like set_of_books_name
621: and set_of_books_id = sob_id;
622:

Line 635: FROM gl_plcy_mst

631: FROM gl_acct_mst
632: WHERE acct_id = p_acct_id;
633:
634: SELECT segment_delimiter INTO x_segment_delimiter
635: FROM gl_plcy_mst
636: WHERE co_code = v_co_code
637: AND delete_mark = 0;
638:
639: PrintLn('calling parse_account');

Line 727: gl_plcy_mst pm,

723: --f.segment_num segment_ref, Bug 3299321
724: p.segment_no segment_ref,
725: pm.segment_delimiter
726: FROM gl_plcy_seg p,
727: gl_plcy_mst pm,
728: fnd_id_flex_segments f,
729: gl_sets_of_books s
730: WHERE p.co_code = v_co_code
731: AND p.delete_mark = 0