APPS.GL_GLRGNJ_XMLP_PKG dependencies on GL_LEDGER_SET_ASSIGNMENTS

Line 114: LEDGER_FROM := 'GL_LEDGER_SET_ASSIGNMENTS LS,';

110: /*srw.message('00', t_errorbuffer);*/null;
111: raise_application_error(-20101,null);/*srw.program_abort;*/null;
112: end;
113: IF (PARAM_LEDGER_TYPE = 'S') THEN
114: LEDGER_FROM := 'GL_LEDGER_SET_ASSIGNMENTS LS,';
115: LEDGER_WHERE := 'LS.ledger_set_id = ' || to_char(P_LEDGER_ID) || ' AND ' ||
116: 'D.ledger_id = LS.ledger_id AND ';
117: ELSE
118: LEDGER_FROM := ' ';

Line 159: gl_ledger_set_assignments b

155: ELSIF (p_ledger_id is not null and param_ledger_type = 'S') THEN
156: SELECT min(a.start_date),max(a.end_date)
157: INTO t_p_start_date, t_p_end_date
158: FROM gl_period_statuses a,
159: gl_ledger_set_assignments b
160: WHERE b.ledger_set_id = p_ledger_id
161: AND a.application_id = 101
162: AND a.closing_status <> 'N'
163: AND a.ledger_id = b.ledger_id;