DBA Data[Home] [Help]

APPS.PSB_POSITIONS_PVT dependencies on PSB_ENTITY_SET

Line 3183: psb_entity_set e,

3179: FROM psb_default_assignments a,
3180: psb_defaults b,
3181: psb_set_relations c,
3182: psb_budget_positions d,
3183: psb_entity_set e,
3184: psb_entity_assignment f
3185: WHERE a.default_rule_id = b.default_rule_id
3186: -- AND f.priority IS NOT NULL
3187: AND b.default_rule_id = c.default_rule_id

Line 3213: psb_entity_set c,

3209: a.element_value,
3210: a.currency_code
3211: FROM psb_default_assignments a,
3212: psb_defaults b,
3213: psb_entity_set c,
3214: psb_entity_assignment d
3215: WHERE a.default_rule_id = b.default_rule_id
3216: AND b.global_default_flag = 'Y'
3217: AND b.data_extract_id = p_data_extract_id

Line 3415: psb_entity_set e,

3411: a.overwrite
3412: FROM psb_defaults a,
3413: psb_set_relations b,
3414: psb_budget_positions c,
3415: psb_entity_set e,
3416: psb_entity_assignment f
3417: WHERE EXISTS -- Bug 4226623 added the exists clause
3418: (SELECT 1
3419: FROM PSB_DEFAULT_ACCOUNT_DISTRS d

Line 3437: psb_entity_set b,

3433: c.priority priority,
3434: a.global_default_flag,
3435: a.overwrite
3436: FROM psb_defaults a,
3437: psb_entity_set b,
3438: psb_entity_assignment c
3439: WHERE EXISTS (SELECT 1
3440: FROM PSB_DEFAULT_ACCOUNT_DISTRS d
3441: WHERE d.default_rule_id = a.default_rule_id)