APPS.PA_PAXBUBSS_XMLP_PKG dependencies on PA_BUDGET_TYPES

Line 102: PA_BUDGET_TYPES

98: BUDGET_TYPE_CODE,
99: BUDGET_TYPE
100: INTO P_COST_BGT_CODE,P_COST_BGT_TYPE
101: FROM
102: PA_BUDGET_TYPES
103: WHERE BUDGET_AMOUNT_CODE = 'C'
104: AND PREDEFINED_FLAG = 'Y'
105: AND BUDGET_TYPE_CODE = 'AC';
106: C_COST_BGT_CODE := P_COST_BGT_CODE;

Line 113: PA_BUDGET_TYPES

109: SELECT
110: BUDGET_TYPE
111: INTO P_COST_BGT_TYPE
112: FROM
113: PA_BUDGET_TYPES
114: WHERE BUDGET_TYPE_CODE = COST_BGT_CODE;
115: C_COST_BGT_CODE := COST_BGT_CODE;
116: C_COST_BGT_NAME := P_COST_BGT_TYPE;
117: END IF;

Line 124: PA_BUDGET_TYPES

120: BUDGET_TYPE_CODE,
121: BUDGET_TYPE
122: INTO P_REV_BGT_CODE,P_REV_BGT_TYPE
123: FROM
124: PA_BUDGET_TYPES
125: WHERE BUDGET_AMOUNT_CODE = 'R'
126: AND PREDEFINED_FLAG = 'Y'
127: AND BUDGET_TYPE_CODE = 'AR';
128: C_REV_BGT_CODE := P_REV_BGT_CODE;

Line 135: PA_BUDGET_TYPES

131: SELECT
132: BUDGET_TYPE
133: INTO P_REV_BGT_TYPE
134: FROM
135: PA_BUDGET_TYPES
136: WHERE BUDGET_TYPE_CODE = REV_BGT_CODE;
137: C_REV_BGT_CODE := REV_BGT_CODE;
138: C_REV_BGT_NAME := P_REV_BGT_TYPE;
139: END IF;