APPS.PA_PAXMGTSD_XMLP_PKG dependencies on PA_BUDGET_TYPES

Line 91: PA_BUDGET_TYPES

87: BUDGET_TYPE_CODE,
88: BUDGET_TYPE
89: INTO P_COST_BGT_CODE,P_COST_BGT_TYPE
90: FROM
91: PA_BUDGET_TYPES
92: WHERE BUDGET_AMOUNT_CODE = 'C'
93: AND PREDEFINED_FLAG = 'Y'
94: AND BUDGET_TYPE_CODE = 'AC';
95: C_COST_BGT_CODE := P_COST_BGT_CODE;

Line 102: PA_BUDGET_TYPES

98: SELECT
99: BUDGET_TYPE
100: INTO P_COST_BGT_TYPE
101: FROM
102: PA_BUDGET_TYPES
103: WHERE BUDGET_TYPE_CODE = COST_BGT_CODE;
104: C_COST_BGT_CODE := COST_BGT_CODE;
105: C_COST_BGT_NAME := P_COST_BGT_TYPE;
106: END IF;

Line 113: PA_BUDGET_TYPES

109: BUDGET_TYPE_CODE,
110: BUDGET_TYPE
111: INTO P_REV_BGT_CODE,P_REV_BGT_TYPE
112: FROM
113: PA_BUDGET_TYPES
114: WHERE BUDGET_AMOUNT_CODE = 'R'
115: AND PREDEFINED_FLAG = 'Y'
116: AND BUDGET_TYPE_CODE = 'AR';
117: C_REV_BGT_CODE := P_REV_BGT_CODE;

Line 124: PA_BUDGET_TYPES

120: SELECT
121: BUDGET_TYPE
122: INTO P_REV_BGT_TYPE
123: FROM
124: PA_BUDGET_TYPES
125: WHERE BUDGET_TYPE_CODE = REV_BGT_CODE;
126: C_REV_BGT_CODE := REV_BGT_CODE;
127: C_REV_BGT_NAME := P_REV_BGT_TYPE;
128: END IF;