DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on PSB_POSITION_PAY_DISTRIBUTIONS

Line 4443: from PSB_POSITION_PAY_DISTRIBUTIONS

4439: select code_combination_id,
4440: distribution_percent,
4441: effective_start_date,
4442: effective_end_date
4443: from PSB_POSITION_PAY_DISTRIBUTIONS
4444: where position_id = p_position_id
4445: and worksheet_id = p_budget_revision_id
4446: and code_combination_id is not null
4447: and chart_of_accounts_id = g_flex_code

Line 4464: from PSB_POSITION_PAY_DISTRIBUTIONS

4460: select code_combination_id,
4461: distribution_percent,
4462: effective_start_date,
4463: effective_end_date
4464: from PSB_POSITION_PAY_DISTRIBUTIONS
4465: where position_id = p_position_id
4466: and worksheet_id is null
4467: and code_combination_id is not null
4468: and chart_of_accounts_id = g_flex_code

Line 4691: from PSB_POSITION_PAY_DISTRIBUTIONS

4687: and assignment_type = 'ELEMENT';
4688:
4689: cursor c_accdistr is
4690: select *
4691: from PSB_POSITION_PAY_DISTRIBUTIONS
4692: where worksheet_id = p_budget_revision_id;
4693:
4694: cursor c_Positions is
4695: select *