DBA Data[Home] [Help]

APPS.PSB_WS_POS1 dependencies on PSB_SET_RELATIONS

Line 1117: from PSB_SET_RELATIONS a,

1113:
1114: cursor c_Budget_Group (CCID NUMBER) is
1115: select a.budget_group_id,
1116: b.num_proposed_years
1117: from PSB_SET_RELATIONS a,
1118: PSB_BUDGET_GROUPS b,
1119: PSB_BUDGET_ACCOUNTS c
1120: where a.budget_group_id = b.budget_group_id
1121: and b.effective_start_date <= PSB_WS_ACCT1.g_startdate_pp

Line 4422: PSB_SET_RELATIONS c,

4418: a.segment29, a.segment30,
4419: a.effective_start_date, a.effective_end_date
4420: from PSB_PAY_ELEMENT_DISTRIBUTIONS a,
4421: PSB_ELEMENT_POS_SET_GROUPS b,
4422: PSB_SET_RELATIONS c,
4423: PSB_BUDGET_POSITIONS d
4424: where a.chart_of_accounts_id = p_flex_code
4425: and (((a.effective_start_date <= p_end_date)
4426: and (a.effective_end_date is null))