APPS.PSB_PSBRPPSV_XMLP_PKG dependencies on PSB_BUDGET_STAGES

Line 17: PSB_BUDGET_STAGES

13: CURSOR STAGENAME_CUR IS
14: SELECT
15: NAME
16: FROM
17: PSB_BUDGET_STAGES
18: WHERE BUDGET_STAGE_ID = P_STAGE1;
19: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
20: BEGIN
21: OPEN STAGENAME_CUR;

Line 19: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

15: NAME
16: FROM
17: PSB_BUDGET_STAGES
18: WHERE BUDGET_STAGE_ID = P_STAGE1;
19: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
20: BEGIN
21: OPEN STAGENAME_CUR;
22: FETCH STAGENAME_CUR
23: INTO STAGENAME;

Line 36: PSB_BUDGET_STAGES

32: CURSOR STAGENAME_CUR IS
33: SELECT
34: NAME
35: FROM
36: PSB_BUDGET_STAGES
37: WHERE BUDGET_STAGE_ID = P_STAGE2;
38: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
39: BEGIN
40: OPEN STAGENAME_CUR;

Line 38: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

34: NAME
35: FROM
36: PSB_BUDGET_STAGES
37: WHERE BUDGET_STAGE_ID = P_STAGE2;
38: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
39: BEGIN
40: OPEN STAGENAME_CUR;
41: FETCH STAGENAME_CUR
42: INTO STAGENAME;

Line 55: PSB_BUDGET_STAGES

51: CURSOR STAGENAME_CUR IS
52: SELECT
53: NAME
54: FROM
55: PSB_BUDGET_STAGES
56: WHERE BUDGET_STAGE_ID = P_STAGE3;
57: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
58: BEGIN
59: OPEN STAGENAME_CUR;

Line 57: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

53: NAME
54: FROM
55: PSB_BUDGET_STAGES
56: WHERE BUDGET_STAGE_ID = P_STAGE3;
57: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
58: BEGIN
59: OPEN STAGENAME_CUR;
60: FETCH STAGENAME_CUR
61: INTO STAGENAME;

Line 116: PSB_BUDGET_STAGES PBS,

112: PSB_WS_ACCOUNT_LINES PWAL,
113: PSB_SERVICE_PACKAGES PSP,
114: PSB_BUDGET_GROUPS PBG,
115: PSB_BUDGET_STAGE_SETS PBSS,
116: PSB_BUDGET_STAGES PBS,
117: PSB_WS_FTE_LINES PWFL,
118: PSB_WS_POSITION_LINES PWPL,
119: PSB_POSITIONS PP,
120: PSB_BUDGET_PERIODS PBP