APPS.PA_PAXEXCPD_XMLP_PKG dependencies on PA_IMPLEMENTATIONS

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

36: FIELD=":p_rule_optimizer"
37: PRINT_ERROR="N"');*/null;
38:
39:
40: select nvl(paimp.org_id,-99) into org_id1 from pa_implementations paimp;
41:
42:
43: select nvl(fnd_profile.value_specific('PA_EN_NEW_GLDATE_DERIVATION'),'N') into pa_new_gl_date from dual;
44:

Line 86: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp

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

Line 93: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp

89: AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;
90:
91: SELECT END_DATE
92: INTO END_DATE
93: FROM GL_PERIOD_STATUSES gps, PA_IMPLEMENTATIONS imp
94: WHERE gps.PERIOD_NAME= END_PERIOD
95: AND gps.APPLICATION_ID = 8721
96: AND gps.SET_OF_BOOKS_ID = imp.set_of_books_id;
97:

Line 121: FROM gl_sets_of_books gl,pa_implementations pi

117: l_name gl_sets_of_books.name%TYPE;
118: BEGIN
119: SELECT gl.name
120: INTO l_name
121: FROM gl_sets_of_books gl,pa_implementations pi
122: WHERE gl.set_of_books_id = pi.set_of_books_id;
123:
124: c_company_name_header := l_name;
125:

Line 178: pa_implementations pi

174:
175: select hr.name
176: into v_ou_name
177: from hr_all_organization_units_tl hr,
178: pa_implementations pi
179: where hr.organization_id(+) = pi.org_id
180: and decode(hr.organization_id,null,'1',hr.language)=
181: decode(hr.organization_id,null,'1',userenv('lang')) ;
182:

Line 261: pa_implementations pi

257:
258: select hr.name
259: into v_ou_name
260: from hr_all_organization_units_tl hr,
261: pa_implementations pi
262: where hr.organization_id(+) = pi.org_id
263: and decode(hr.organization_id,null,'1',hr.language)=
264: decode(hr.organization_id,null,'1',userenv('lang')) ;
265: return (v_ou_name);