APPS.PA_PAXEXCPS_XMLP_PKG dependencies on PA_IMPLEMENTATIONS

Line 48: select nvl(paimp.org_id,-99) into org_id1 from pa_implementations paimp;

44: FIELD=":p_min_precision"
45: PRINT_ERROR="N"');*/null;
46:
47:
48: select nvl(paimp.org_id,-99) into org_id1 from pa_implementations paimp;
49:
50:
51:
52:

Line 82: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp

78: elsif (calling_mode = 'GL') then
79:
80: SELECT START_DATE
81: INTO START_DATE
82: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp
83: WHERE gps.PERIOD_NAME= START_PERIOD
84: AND gps.APPLICATION_ID = 8721
85: AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;
86:

Line 89: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp

85: AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;
86:
87: SELECT END_DATE
88: INTO END_DATE
89: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp
90: WHERE gps.PERIOD_NAME= END_PERIOD
91: AND gps.APPLICATION_ID = 8721
92: AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;
93:

Line 117: FROM gl_sets_of_books gl,pa_implementations pi

113: l_name gl_sets_of_books.name%TYPE;
114: BEGIN
115: SELECT gl.name
116: INTO l_name
117: FROM gl_sets_of_books gl,pa_implementations pi
118: WHERE gl.set_of_books_id = pi.set_of_books_id;
119:
120: c_company_name_header := l_name;
121:

Line 154: from hr_all_organization_units_tl hr, pa_implementations pi

150:
151: BEGIN
152: select substr(hr.name,1,60)
153: into v_ou_name
154: from hr_all_organization_units_tl hr, pa_implementations pi
155: where hr.organization_id(+) = pi.org_id and
156: decode(hr.organization_id,null,'1',hr.language)=
157: decode(hr.organization_id,null,'1',userenv('lang'));
158: