DBA Data[Home] [Help]

APPS.PO_FUNDS_CHECKER dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 35: g_sobid financials_system_parameters.set_of_books_id%TYPE;

31: g_conc_flag VARCHAR2(1);
32:
33: -- Set of Books ID
34:
35: g_sobid financials_system_parameters.set_of_books_id%TYPE;
36:
37: -- PO Mode
38:
39: g_pomode VARCHAR2(15);

Line 213: from financials_system_parameters

209: and packet_id = packet_id);
210:
211: cursor req_enc is
212: select 'Y'
213: from financials_system_parameters
214: where req_encumbrance_flag = 'Y';
215:
216: BEGIN
217:

Line 335: FINANCIALS_SYSTEM_PARAMETERS FSP,

331:
332: SELECT FC.MINIMUM_ACCOUNTABLE_UNIT, FC.PRECISION
333: INTO l_min_acct_unit , l_precision
334: FROM GL_SETS_OF_BOOKS GLSOB,
335: FINANCIALS_SYSTEM_PARAMETERS FSP,
336: FND_CURRENCIES FC
337: WHERE GLSOB.set_of_books_id = FSP.set_of_books_id
338: AND FC.currency_code = GLSOB.currency_code;
339:

Line 860: from financials_system_parameters fsp;

856:
857: cursor pkt is
858: select gl_bc_packets_s.nextval,
859: fsp.set_of_books_id
860: from financials_system_parameters fsp;
861:
862: BEGIN
863:
864: open pkt;

Line 1116: 'financials_system_parameters fsp, ' ||

1112: 'porl.reference_num, ' ||
1113: 'substr(porl.item_description, 1, 40) ' ||
1114: 'from gl_periods glp, ' ||
1115: 'gl_sets_of_books glsob, ' ||
1116: 'financials_system_parameters fsp, ' ||
1117: 'fnd_currencies base_cur, ' ||
1118: 'po_req_distributions pord, ' ||
1119: 'po_requisition_lines porl, ' ||
1120: 'po_requisition_headers prh ' ||

Line 1299: 'financials_system_parameters fsp, ' ||

1295: 'prh.segment1), ' ||
1296: 'substr(pol.item_description, 1, 40) ' ||
1297: 'from gl_periods glp, ' ||
1298: 'gl_sets_of_books glsob, ' ||
1299: 'financials_system_parameters fsp, ' ||
1300: 'fnd_currencies doc_cur, ' ||
1301: 'po_distributions pod, ' ||
1302: 'po_line_locations poll, ' ||
1303: 'po_lines pol, ' ||

Line 1392: 'financials_system_parameters fsp, ' ||

1388: 'porl.reference_num, ' ||
1389: 'substr(porl.item_description, 1, 40) ' ||
1390: 'from gl_periods glp, ' ||
1391: 'gl_sets_of_books glsob, ' ||
1392: 'financials_system_parameters fsp, ' ||
1393: 'fnd_currencies base_cur, ' ||
1394: 'po_req_distributions pord, ' ||
1395: 'po_requisition_lines porl, ' ||
1396: 'po_requisition_headers prh, ' ||

Line 1593: 'financials_system_parameters fsp, ' ||

1589: 'prh.segment1), ' ||
1590: 'substr(pol.item_description, 1, 40) ' ||
1591: 'from gl_periods glp, ' ||
1592: 'gl_sets_of_books glsob, ' ||
1593: 'financials_system_parameters fsp, ' ||
1594: 'fnd_currencies doc_cur, ' ||
1595: 'po_distributions pod, ' ||
1596: 'po_line_locations poll, ' ||
1597: 'po_lines pol, ' ||

Line 1688: 'financials_system_parameters fsp, ' ||

1684: 'porl.reference_num, ' ||
1685: 'substr(porl.item_description, 1, 40) ' ||
1686: 'from gl_periods glp, ' ||
1687: 'gl_sets_of_books glsob, ' ||
1688: 'financials_system_parameters fsp, ' ||
1689: 'fnd_currencies base_cur, ' ||
1690: 'po_req_distributions pord, ' ||
1691: 'po_requisition_lines porl, ' ||
1692: 'po_requisition_headers prh, ' ||

Line 1889: 'financials_system_parameters fsp, ' ||

1885: 'prh.segment1), ' ||
1886: 'substr(pol.item_description, 1, 40) ' ||
1887: 'from gl_periods glp, ' ||
1888: 'gl_sets_of_books glsob, ' ||
1889: 'financials_system_parameters fsp, ' ||
1890: 'fnd_currencies doc_cur, ' ||
1891: 'po_distributions prd, ' ||
1892: 'po_line_locations prll, ' ||
1893: 'po_lines pol, ' ||

Line 1991: 'financials_system_parameters fsp, ' ||

1987: 'prh.segment1), ' ||
1988: 'substr(porl.item_description, 1, 40) ' ||
1989: 'from gl_periods glp, ' ||
1990: 'gl_sets_of_books glsob, ' ||
1991: 'financials_system_parameters fsp, ' ||
1992: 'fnd_currencies doc_cur, ' ||
1993: 'po_distributions prd, ' ||
1994: 'po_line_locations prll, ' ||
1995: 'po_lines pol, ' ||