DBA Data[Home] [Help]

APPS.PSB_WS_POS1 dependencies on PSB_ELEMENT_POS_SET_GROUPS

Line 3132: FROM psb_element_pos_set_groups pepsg ,

3128: CURSOR c_pos_group IS
3129: SELECT pay_element_id,
3130: distribution_percent,
3131: code_combination_id
3132: FROM psb_element_pos_set_groups pepsg ,
3133: psb_pay_element_distributions pped
3134: WHERE pepsg.position_set_group_id = pped.position_set_group_id
3135: AND pepsg.pay_element_id = p_pay_element_id
3136: AND code_combination_id = l_ccid;

Line 4421: PSB_ELEMENT_POS_SET_GROUPS b,

4417: a.segment25, a.segment26, a.segment27, a.segment28,
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)