DBA Data[Home] [Help]

APPS.PAY_PYSG8SAD_XMLP_PKG dependencies on FND_DATE

Line 188: CP_AW_FR_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');

184: l_aw_fr_date := PAY_BALANCE_PKG.RUN_DB_ITEM
185: ( P_DATABASE_NAME => 'X_DTM502'
186: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
187: ,P_LEGISLATION_CODE => 'SG' );
188: CP_AW_FR_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');
189:
190: l_aw_to_date := PAY_BALANCE_PKG.RUN_DB_ITEM
191: ( P_DATABASE_NAME => 'X_DTM503'
192: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID

Line 194: CP_AW_TO_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');

190: l_aw_to_date := PAY_BALANCE_PKG.RUN_DB_ITEM
191: ( P_DATABASE_NAME => 'X_DTM503'
192: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
193: ,P_LEGISLATION_CODE => 'SG' );
194: CP_AW_TO_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');
195:
196: l_refund_date := PAY_BALANCE_PKG.RUN_DB_ITEM
197: ( P_DATABASE_NAME => 'X_DTM504'
198: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID

Line 200: CP_REFUND_DATE := to_char(fnd_date.canonical_to_date(l_refund_date),'DD-MON-YYYY');

196: l_refund_date := PAY_BALANCE_PKG.RUN_DB_ITEM
197: ( P_DATABASE_NAME => 'X_DTM504'
198: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
199: ,P_LEGISLATION_CODE => 'SG' );
200: CP_REFUND_DATE := to_char(fnd_date.canonical_to_date(l_refund_date),'DD-MON-YYYY');
201:
202: CP_ER_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM
203: ( P_DATABASE_NAME => 'X_MOA411'
204: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID

Line 216: CP_ER_DATE := to_char(fnd_date.canonical_to_date(l_er_date),'DD-MON-YYYY');

212: l_er_date := PAY_BALANCE_PKG.RUN_DB_ITEM
213: ( P_DATABASE_NAME => 'X_DTM505'
214: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
215: ,P_LEGISLATION_CODE => 'SG' );
216: CP_ER_DATE := to_char(fnd_date.canonical_to_date(l_er_date),'DD-MON-YYYY');
217:
218: CP_EE_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM
219: ( P_DATABASE_NAME => 'X_MOA413'
220: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID

Line 232: CP_EE_DATE := to_char(fnd_date.canonical_to_date(l_ee_date),'DD-MON-YYYY');

228: l_ee_date := PAY_BALANCE_PKG.RUN_DB_ITEM
229: ( P_DATABASE_NAME => 'X_DTM506'
230: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
231: ,P_LEGISLATION_CODE => 'SG' );
232: CP_EE_DATE := to_char(fnd_date.canonical_to_date(l_ee_date),'DD-MON-YYYY');
233:
234:
235: END;
236: return 0;