APPS.PAY_PYIEBIKA_XMLP_PKG dependencies on PAY_BALANCE_PKG

Line 116: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ARREARAGE

112:
113: -- Added by Atul
114: pragma autonomous_transaction;
115: BEGIN
116: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ARREARAGE
117: ,ASSIGNMENT_ID
118: ,P_EFFECTIVE_DATE);
119:
120: --insert into log_msg VALUES('ATUL','PYIEBIKA','L_VALUE1',L_VALUE) ;

Line 140: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE

136: BEGIN
137: IF MOD(TO_NUMBER(TO_CHAR(P_EFFECTIVE_DATE
138: ,'YYYY'))
139: ,2) = 0 THEN
140: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE
141: ,ASSIGNMENT_ID
142: ,P_EFFECTIVE_DATE);
143: ELSE
144: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE

Line 144: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE

140: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE
141: ,ASSIGNMENT_ID
142: ,P_EFFECTIVE_DATE);
143: ELSE
144: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE
145: ,ASSIGNMENT_ID
146: ,P_EFFECTIVE_DATE);
147: END IF;
148: -- insert into log_msg VALUES('ATUL','PYIEBIKA','L_VALUE2',L_VALUE) ;

Line 166: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE

162: BEGIN
163: IF MOD(TO_NUMBER(TO_CHAR(P_EFFECTIVE_DATE
164: ,'YYYY'))
165: ,2) = 0 THEN
166: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE
167: ,ASSIGNMENT_ID
168: ,P_EFFECTIVE_DATE);
169: ELSE
170: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE

Line 170: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE

166: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE
167: ,ASSIGNMENT_ID
168: ,P_EFFECTIVE_DATE);
169: ELSE
170: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE
171: ,ASSIGNMENT_ID
172: ,P_EFFECTIVE_DATE);
173: END IF;
174: --insert into log_msg VALUES('ATUL','PYIEBIKA','L_VALUE3',L_VALUE) ;

Line 192: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC

188: BEGIN
189: IF MOD(TO_NUMBER(TO_CHAR(P_EFFECTIVE_DATE
190: ,'YYYY'))
191: ,2) = 0 THEN
192: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC
193: ,ASSIGNMENT_ID
194: ,P_EFFECTIVE_DATE);
195: ELSE
196: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC

Line 196: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC

192: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC
193: ,ASSIGNMENT_ID
194: ,P_EFFECTIVE_DATE);
195: ELSE
196: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC
197: ,ASSIGNMENT_ID
198: ,P_EFFECTIVE_DATE);
199: END IF;
200: -- insert into log_msg VALUES('ATUL','PYIEBIKA','L_VALUE4',L_VALUE) ;

Line 218: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC

214: BEGIN
215: IF MOD(TO_NUMBER(TO_CHAR(P_EFFECTIVE_DATE
216: ,'YYYY'))
217: ,2) = 0 THEN
218: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC
219: ,ASSIGNMENT_ID
220: ,P_EFFECTIVE_DATE);
221: ELSE
222: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC

Line 222: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC

218: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_EVEN_ARREARAGE_REC
219: ,ASSIGNMENT_ID
220: ,P_EFFECTIVE_DATE);
221: ELSE
222: L_VALUE := PAY_BALANCE_PKG.GET_VALUE(CP_IE_BIK_ODD_ARREARAGE_REC
223: ,ASSIGNMENT_ID
224: ,P_EFFECTIVE_DATE);
225: END IF;
226: --insert into log_msg VALUES('ATUL','PYIEBIKA','L_VALUE5',L_VALUE) ;