APPS.PSB_POSITIONS_PVT dependencies on PSB_SET_RELATIONS

Line 3145: PSB_SET_RELATIONS c,

3141: a.element_value,
3142: a.currency_code
3143: FROM PSB_DEFAULT_ASSIGNMENTS a,
3144: PSB_DEFAULTS b,
3145: PSB_SET_RELATIONS c,
3146: PSB_BUDGET_POSITIONS d
3147: WHERE a.default_rule_id = b.default_rule_id
3148: AND b.priority is not null
3149: AND b.default_rule_id = c.default_rule_id

Line 3181: psb_set_relations c,

3177: a.element_value,
3178: a.currency_code
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

Line 3384: PSB_SET_RELATIONS b,

3380: SELECT a.default_rule_id,
3381: a.priority,
3382: a.global_default_flag
3383: FROM PSB_DEFAULTS a,
3384: PSB_SET_RELATIONS b,
3385: PSB_BUDGET_POSITIONS c
3386: WHERE EXISTS
3387: (SELECT 1
3388: FROM PSB_DEFAULT_ACCOUNT_DISTRS d

Line 3413: psb_set_relations b,

3409: f.priority priority,
3410: a.global_default_flag,
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

Line 3736: PSB_SET_RELATIONS c,

3732: a.element_value,
3733: a.currency_code
3734: from PSB_DEFAULT_ASSIGNMENTS a,
3735: PSB_DEFAULTS b,
3736: PSB_SET_RELATIONS c,
3737: PSB_BUDGET_POSITIONS d
3738: where EXISTS
3739: ( select 1
3740: from PSB_PAY_ELEMENTS pe

Line 4915: psb_set_relations d,

4911: FROM
4912: psb_pay_element_distributions a,
4913: psb_pay_elements b,
4914: psb_element_pos_Set_groups c,
4915: psb_set_relations d,
4916: psb_budget_positions e,
4917: psb_position_assignments f
4918: WHERE
4919: a.position_set_group_id = c.position_set_group_id