APPS.PSB_POSITIONS_PVT dependencies on PSB_WORKSHEETS

Line 4076: FROM psb_worksheets

4072: WHERE position_id = p_position_id ;
4073: cursor worksheet_csr IS
4074: SELECT worksheet_id,local_copy_flag,global_worksheet_id,
4075: budget_calendar_id
4076: FROM psb_worksheets
4077: WHERE worksheet_id = p_worksheet_id ;
4078: cursor calendar_csr IS
4079: SELECT min(start_date) , max(end_date)
4080: FROM psb_worksheets w,psb_budget_periods b

Line 4080: FROM psb_worksheets w,psb_budget_periods b

4076: FROM psb_worksheets
4077: WHERE worksheet_id = p_worksheet_id ;
4078: cursor calendar_csr IS
4079: SELECT min(start_date) , max(end_date)
4080: FROM psb_worksheets w,psb_budget_periods b
4081: WHERE b.budget_calendar_id = w.budget_calendar_id AND
4082: w.worksheet_id = l_out_worksheet_id AND
4083: budget_period_type = 'Y';
4084: cursor rev_csr IS

Line 4467: FROM psb_worksheets

4463: CURSOR c_ws IS
4464: SELECT data_extract_id,
4465: budget_calendar_id,
4466: budget_group_id
4467: FROM psb_worksheets
4468: WHERE worksheet_id = p_worksheet_id;
4469:
4470: CURSOR c_bg IS
4471: SELECT nvl(root_budget_group_id,budget_group_id) ,

Line 4683: FROM psb_worksheets

4679: CURSOR c_ws IS
4680: SELECT data_extract_id,
4681: budget_calendar_id,
4682: budget_group_id
4683: FROM psb_worksheets
4684: WHERE worksheet_id = p_worksheet_id;
4685:
4686: CURSOR c_job IS
4687: SELECT 'Job Exists'