DBA Data[Home] [Help]

APPS.POA_SAVINGS_SAV dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 113: financials_system_params_all fsp1,

109: and poga.enabled_flag = 'Y'
110: and ((poga.purchasing_org_id in
111: (select tfh.start_org_id
112: from mtl_procuring_txn_flow_hdrs_v tfh,
113: financials_system_params_all fsp1,
114: financials_system_params_all fsp2
115: where p_creation_date between nvl(tfh.start_date,p_creation_date)
116: and nvl(tfh.end_date,p_creation_date)
117: and fsp1.org_id = tfh.start_org_id

Line 114: financials_system_params_all fsp2

110: and ((poga.purchasing_org_id in
111: (select tfh.start_org_id
112: from mtl_procuring_txn_flow_hdrs_v tfh,
113: financials_system_params_all fsp1,
114: financials_system_params_all fsp2
115: where p_creation_date between nvl(tfh.start_date,p_creation_date)
116: and nvl(tfh.end_date,p_creation_date)
117: and fsp1.org_id = tfh.start_org_id
118: and fsp1.purch_encumbrance_flag = 'N'

Line 251: financials_system_params_all fsp1,

247: and poga.enabled_flag = 'Y'
248: and ((poga.purchasing_org_id in
249: (select tfh.start_org_id
250: from mtl_procuring_txn_flow_hdrs_v tfh,
251: financials_system_params_all fsp1,
252: financials_system_params_all fsp2
253: where p_creation_date between nvl(tfh.start_date,p_creation_date)
254: and nvl(tfh.end_date,p_creation_date)
255: and fsp1.org_id = tfh.start_org_id

Line 252: financials_system_params_all fsp2

248: and ((poga.purchasing_org_id in
249: (select tfh.start_org_id
250: from mtl_procuring_txn_flow_hdrs_v tfh,
251: financials_system_params_all fsp1,
252: financials_system_params_all fsp2
253: where p_creation_date between nvl(tfh.start_date,p_creation_date)
254: and nvl(tfh.end_date,p_creation_date)
255: and fsp1.org_id = tfh.start_org_id
256: and fsp1.purch_encumbrance_flag = 'N'