DBA Data[Home] [Help]

APPS.PSB_WS_POS2 dependencies on PSB_SET_RELATIONS

Line 3728: PSB_SET_RELATIONS d

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))
3732: or b.global_default_flag = 'Y')

Line 3749: PSB_SET_RELATIONS d

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))
3753: or b.global_default_flag = 'Y')

Line 3770: PSB_SET_RELATIONS d

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))
3774: or b.global_default_flag = 'Y')

Line 4279: PSB_SET_RELATIONS c,

4275: a.distribution_percent,
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))