DBA Data[Home] [Help]

APPS.POA_SAVINGS_NP dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 134: financials_system_params_all fsp1,

130: and poga.enabled_flag = 'Y'
131: and ((poga.purchasing_org_id in
132: (select /*+ leading(tfh) */ tfh.start_org_id
133: from mtl_transaction_flow_headers tfh,
134: financials_system_params_all fsp1,
135: financials_system_params_all fsp2
136: where pod.creation_date between nvl(tfh.start_date,pod.creation_date)
137: and nvl(tfh.end_date,pod.creation_date)
138: and tfh.flow_type = 2

Line 135: financials_system_params_all fsp2

131: and ((poga.purchasing_org_id in
132: (select /*+ leading(tfh) */ tfh.start_org_id
133: from mtl_transaction_flow_headers tfh,
134: financials_system_params_all fsp1,
135: financials_system_params_all fsp2
136: where pod.creation_date between nvl(tfh.start_date,pod.creation_date)
137: and nvl(tfh.end_date,pod.creation_date)
138: and tfh.flow_type = 2
139: and fsp1.org_id = tfh.start_org_id

Line 559: financials_system_params_all fsp1,

555: and poga.enabled_flag = 'Y'
556: and ((poga.purchasing_org_id in
557: (select tfh.start_org_id
558: from mtl_transaction_flow_headers tfh,
559: financials_system_params_all fsp1,
560: financials_system_params_all fsp2
561: where pod.creation_date between nvl(tfh.start_date,pod.creation_date)
562: and nvl(tfh.end_date,pod.creation_date)
563: and tfh.flow_type = 2

Line 560: financials_system_params_all fsp2

556: and ((poga.purchasing_org_id in
557: (select tfh.start_org_id
558: from mtl_transaction_flow_headers tfh,
559: financials_system_params_all fsp1,
560: financials_system_params_all fsp2
561: where pod.creation_date between nvl(tfh.start_date,pod.creation_date)
562: and nvl(tfh.end_date,pod.creation_date)
563: and tfh.flow_type = 2
564: and fsp1.org_id = tfh.start_org_id