DBA Data[Home] [Help]

APPS.PSB_WS_POS2 dependencies on PSB_BUDGET_POSITIONS

Line 3727: from PSB_BUDGET_POSITIONS c,

3723: and a.allocation_rule_id = b.entity_id
3724: and ((nvl(b.global_default_flag, 'N') = 'N'
3725: and exists
3726: (select 1
3727: from PSB_BUDGET_POSITIONS c,
3728: PSB_SET_RELATIONS d
3729: where c.position_id = p_position_id
3730: and c.account_position_set_id = d.account_position_set_id
3731: and d.default_rule_id = b.default_rule_id))

Line 3748: from PSB_BUDGET_POSITIONS c,

3744: and a.allocation_rule_id = b.entity_id
3745: and ((nvl(b.global_default_flag, 'N') = 'N'
3746: and exists
3747: (select 1
3748: from PSB_BUDGET_POSITIONS c,
3749: PSB_SET_RELATIONS d
3750: where c.position_id = p_position_id
3751: and c.account_position_set_id = d.account_position_set_id
3752: and d.default_rule_id = b.default_rule_id))

Line 3769: from PSB_BUDGET_POSITIONS c,

3765: and a.allocation_rule_id = b.entity_id
3766: and ((nvl(b.global_default_flag, 'N') = 'N'
3767: and exists
3768: (select 1
3769: from PSB_BUDGET_POSITIONS c,
3770: PSB_SET_RELATIONS d
3771: where c.position_id = p_position_id
3772: and c.account_position_set_id = d.account_position_set_id
3773: and d.default_rule_id = b.default_rule_id))

Line 4280: PSB_BUDGET_POSITIONS d

4276: a.effective_start_date, a.effective_end_date
4277: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
4278: PSB_ELEMENT_POS_SET_GROUPS b,
4279: PSB_SET_RELATIONS c,
4280: PSB_BUDGET_POSITIONS d
4281: where a.chart_of_accounts_id = p_flex_code
4282: and (((a.effective_start_date <= p_end_date)
4283: and (a.effective_end_date is null))
4284: or ((a.effective_start_date between p_start_date and p_end_date)