eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_PSBRPACV_XMLP_PKG dependencies on PSB_BUDGET_STAGES

Line 10: PSB_BUDGET_STAGES

6: CURSOR STAGENAME_CUR IS
7: SELECT
8: NAME
9: FROM
10: PSB_BUDGET_STAGES
11: WHERE BUDGET_STAGE_ID = P_STAGE1;
12: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
13: BEGIN
14: OPEN STAGENAME_CUR;

Line 12: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

8: NAME
9: FROM
10: PSB_BUDGET_STAGES
11: WHERE BUDGET_STAGE_ID = P_STAGE1;
12: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
13: BEGIN
14: OPEN STAGENAME_CUR;
15: FETCH STAGENAME_CUR
16: INTO STAGENAME;

Line 29: PSB_BUDGET_STAGES

25: CURSOR STAGENAME_CUR IS
26: SELECT
27: NAME
28: FROM
29: PSB_BUDGET_STAGES
30: WHERE BUDGET_STAGE_ID = P_STAGE2;
31: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
32: BEGIN
33: OPEN STAGENAME_CUR;

Line 31: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

27: NAME
28: FROM
29: PSB_BUDGET_STAGES
30: WHERE BUDGET_STAGE_ID = P_STAGE2;
31: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
32: BEGIN
33: OPEN STAGENAME_CUR;
34: FETCH STAGENAME_CUR
35: INTO STAGENAME;

Line 48: PSB_BUDGET_STAGES

44: CURSOR STAGENAME_CUR IS
45: SELECT
46: NAME
47: FROM
48: PSB_BUDGET_STAGES
49: WHERE BUDGET_STAGE_ID = P_STAGE3;
50: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
51: BEGIN
52: OPEN STAGENAME_CUR;

Line 50: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

46: NAME
47: FROM
48: PSB_BUDGET_STAGES
49: WHERE BUDGET_STAGE_ID = P_STAGE3;
50: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
51: BEGIN
52: OPEN STAGENAME_CUR;
53: FETCH STAGENAME_CUR
54: INTO STAGENAME;

Line 71: PSB_BUDGET_STAGES

67: CURSOR STAGENAME_CUR IS
68: SELECT
69: NAME
70: FROM
71: PSB_BUDGET_STAGES
72: WHERE BUDGET_STAGE_ID = P_STAGE4;
73: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
74: BEGIN
75: OPEN STAGENAME_CUR;

Line 73: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;

69: NAME
70: FROM
71: PSB_BUDGET_STAGES
72: WHERE BUDGET_STAGE_ID = P_STAGE4;
73: STAGENAME PSB_BUDGET_STAGES.NAME%TYPE;
74: BEGIN
75: OPEN STAGENAME_CUR;
76: FETCH STAGENAME_CUR
77: INTO STAGENAME;

Line 108: PSB_BUDGET_STAGES PBS,

104: PSB_WS_ACCOUNT_LINES PWAL,
105: PSB_SERVICE_PACKAGES PSP,
106: PSB_BUDGET_GROUPS PBG,
107: PSB_BUDGET_STAGE_SETS PBSS,
108: PSB_BUDGET_STAGES PBS,
109: PSB_BUDGET_PERIODS PBP
110: WHERE PW.WORKSHEET_ID = PWL.WORKSHEET_ID
111: AND PWL.ACCOUNT_LINE_ID = PWAL.ACCOUNT_LINE_ID
112: AND PW.BUDGET_GROUP_ID = PBG.BUDGET_GROUP_ID