APPS.PA_PAXMGPSD_XMLP_PKG dependencies on PA_BUDGET_TYPES

Line 85: PA_BUDGET_TYPES

81: BUDGET_TYPE_CODE,
82: BUDGET_TYPE
83: INTO P_COST_BGT_CODE,P_COST_BGT_TYPE
84: FROM
85: PA_BUDGET_TYPES
86: WHERE BUDGET_AMOUNT_CODE = 'C'
87: AND PREDEFINED_FLAG = 'Y'
88: AND BUDGET_TYPE_CODE = 'AC';
89: C_COST_BGT_CODE := P_COST_BGT_CODE;

Line 96: PA_BUDGET_TYPES

92: SELECT
93: BUDGET_TYPE
94: INTO P_COST_BGT_TYPE
95: FROM
96: PA_BUDGET_TYPES
97: WHERE BUDGET_TYPE_CODE = COST_BGT_CODE;
98: C_COST_BGT_CODE := COST_BGT_CODE;
99: C_COST_BGT_NAME := P_COST_BGT_TYPE;
100: END IF;

Line 107: PA_BUDGET_TYPES

103: BUDGET_TYPE_CODE,
104: BUDGET_TYPE
105: INTO P_REV_BGT_CODE,P_REV_BGT_TYPE
106: FROM
107: PA_BUDGET_TYPES
108: WHERE BUDGET_AMOUNT_CODE = 'R'
109: AND PREDEFINED_FLAG = 'Y'
110: AND BUDGET_TYPE_CODE = 'AR';
111: C_REV_BGT_CODE := P_REV_BGT_CODE;

Line 118: PA_BUDGET_TYPES

114: SELECT
115: BUDGET_TYPE
116: INTO P_REV_BGT_TYPE
117: FROM
118: PA_BUDGET_TYPES
119: WHERE BUDGET_TYPE_CODE = REV_BGT_CODE;
120: C_REV_BGT_CODE := REV_BGT_CODE;
121: C_REV_BGT_NAME := P_REV_BGT_TYPE;
122: END IF;