APPS.PSB_BUDGET_GROUPS_PVT dependencies on PSB_ACCOUNT_POSITION_SET_LINES

Line 111: from psb_account_position_set_lines cmp,

107: End_Date DATE,
108: Inc_Type IN VARCHAR2 DEFAULT 'I',
109: Def_Seg IN VARCHAR2 DEFAULT 'X') is
110: select 'ACCOUNT RANGE OVERLAP'
111: from psb_account_position_set_lines cmp,
112: psb_account_position_set_lines lst,
113: psb_set_relations a
114: where (
115: NVL(cmp.SEGMENT30_LOW,Def_Seg) <= NVL(lst.SEGMENT30_HIGH,Def_Seg)

Line 112: psb_account_position_set_lines lst,

108: Inc_Type IN VARCHAR2 DEFAULT 'I',
109: Def_Seg IN VARCHAR2 DEFAULT 'X') is
110: select 'ACCOUNT RANGE OVERLAP'
111: from psb_account_position_set_lines cmp,
112: psb_account_position_set_lines lst,
113: psb_set_relations a
114: where (
115: NVL(cmp.SEGMENT30_LOW,Def_Seg) <= NVL(lst.SEGMENT30_HIGH,Def_Seg)
116: AND NVL(cmp.SEGMENT30_HIGH,Def_Seg) >= NVL(lst.SEGMENT30_LOW,Def_Seg)

Line 223: from psb_account_position_set_lines ps,

219:
220: cursor c_Overlap_ps_range (l_ps_AccSet NUMBER,
221: l_nps_AccSet NUMBER) is
222: select 'Personnel Services and Non-Personnel Services Account Sets Overlap'
223: from psb_account_position_set_lines ps,
224: psb_account_position_set_lines nps
225: where (
226: NVL(ps.SEGMENT30_LOW,'X') <= NVL(nps.SEGMENT30_HIGH,'X')
227: AND NVL(ps.SEGMENT30_HIGH,'X') >= NVL(nps.SEGMENT30_LOW,'X')

Line 224: psb_account_position_set_lines nps

220: cursor c_Overlap_ps_range (l_ps_AccSet NUMBER,
221: l_nps_AccSet NUMBER) is
222: select 'Personnel Services and Non-Personnel Services Account Sets Overlap'
223: from psb_account_position_set_lines ps,
224: psb_account_position_set_lines nps
225: where (
226: NVL(ps.SEGMENT30_LOW,'X') <= NVL(nps.SEGMENT30_HIGH,'X')
227: AND NVL(ps.SEGMENT30_HIGH,'X') >= NVL(nps.SEGMENT30_LOW,'X')
228: AND NVL(ps.SEGMENT29_LOW,'X') <= NVL(nps.SEGMENT29_HIGH,'X')