DBA Data[Home] [Help]

APPS.PSB_POSITIONS_I_PVT dependencies on PSB_ENTITY_ASSIGNMENT

Line 182: psb_entity_assignment f

178: psb_defaults b,
179: psb_set_relations c,
180: psb_budget_positions d,
181: psb_entity_set e,
182: psb_entity_assignment f
183: WHERE a.default_rule_id = b.default_rule_id
184: AND b.default_rule_id = c.default_rule_id
185: AND c.account_position_set_id = d.account_position_set_id
186: AND d.data_extract_id = p_data_extract_id

Line 211: psb_entity_assignment d

207: a.currency_code
208: FROM psb_default_assignments a,
209: psb_defaults b,
210: psb_entity_set c,
211: psb_entity_assignment d
212: WHERE a.default_rule_id = b.default_rule_id
213: AND b.global_default_flag = 'Y'
214: AND b.data_extract_id = p_data_extract_id
215: AND c.entity_set_id = d.entity_set_id

Line 238: psb_entity_assignment f

234: FROM psb_defaults a,
235: psb_set_relations b,
236: psb_budget_positions c,
237: psb_entity_set e,
238: psb_entity_assignment f
239: WHERE EXISTS
240: (SELECT 1
241: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
242: WHERE d.default_rule_id = a.default_rule_id)

Line 259: psb_entity_assignment c

255: a.global_default_flag,
256: a.overwrite
257: FROM psb_defaults a,
258: psb_entity_set b,
259: psb_entity_assignment c
260: WHERE EXISTS (SELECT 1
261: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
262: WHERE d.default_rule_id = a.default_rule_id)
263: AND a.global_default_flag = 'Y'