DBA Data[Home] [Help]

APPS.PAY_US_EMPLOYEE_BALANCES dependencies on PAY_US_TAXBAL_VIEW_PKG

Line 211: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,

207: ,pet.element_information11
208: ,pet.element_information12
209: ,pet.element_information14
210: ,decode (p_balance_level,
211: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,
212: 'ASG_GRE_PTD' ,
213: p_assignment_action_id ,
214: NULL,
215: NULL,

Line 220: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

216: p_tax_unit_id,
217: p_business_group_id ,
218: NULL)),
219: 'PER',NULL) PTD_VAL
220: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
221: l_dim_month ,
222: p_assignment_action_id ,
223: NULL,
224: NULL ,

Line 228: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

224: NULL ,
225: p_tax_unit_id,
226: p_business_group_id ,
227: NULL) MONTH_VAL
228: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
229: l_dim_qtd ,
230: p_assignment_action_id ,
231: NULL,
232: NULL ,

Line 236: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

232: NULL ,
233: p_tax_unit_id,
234: p_business_group_id ,
235: NULL) QTD_VAL
236: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
237: l_dim_ytd ,
238: p_assignment_action_id ,--global.assignment_action_id
239: NULL,
240: NULL ,

Line 297: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,

293: ,pet.element_information11
294: ,pet.element_information12
295: ,pet.element_information14
296: ,decode (p_balance_level,
297: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,
298: 'ASG_GRE_PTD' ,
299: p_assignment_action_id ,
300: NULL,
301: NULL,

Line 306: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

302: p_tax_unit_id,
303: p_business_group_id ,
304: NULL)),
305: 'PER',NULL) PTD_VAL
306: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
307: l_dim_month ,
308: p_assignment_action_id ,
309: NULL,
310: NULL ,

Line 314: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

310: NULL ,
311: p_tax_unit_id,
312: p_business_group_id ,
313: NULL) MONTH_VAL
314: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
315: l_dim_qtd ,
316: p_assignment_action_id ,
317: NULL,
318: NULL ,

Line 322: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

318: NULL ,
319: p_tax_unit_id,
320: p_business_group_id ,
321: NULL) QTD_VAL
322: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
323: l_dim_ytd ,
324: p_assignment_action_id ,--global.assignment_action_id
325: NULL,
326: NULL ,

Line 383: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,

379: ,pet.element_information11
380: ,pet.element_information12
381: ,pet.element_information14
382: ,decode (p_balance_level,
383: 'ASG',(PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,
384: 'ASG_GRE_PTD' ,
385: p_assignment_action_id ,
386: NULL,
387: NULL,

Line 392: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

388: p_tax_unit_id,
389: p_business_group_id ,
390: NULL)),
391: 'PER', NULL) PTD_VAL
392: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
393: l_dim_month ,
394: p_assignment_action_id ,
395: NULL,
396: NULL ,

Line 400: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

396: NULL ,
397: p_tax_unit_id,
398: p_business_group_id ,
399: NULL) MONTH_VAL
400: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
401: l_dim_qtd,
402: p_assignment_action_id ,
403: NULL,
404: NULL ,

Line 408: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

404: NULL ,
405: p_tax_unit_id,
406: p_business_group_id ,
407: NULL) QTD_VAL
408: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
409: l_dim_ytd,
410: p_assignment_action_id ,--global.assignment_action_id
411: NULL,
412: NULL ,

Line 468: 'ASG', (PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,

464: ,pet2.element_information11
465: ,pet2.element_information12
466: ,pet2.element_information14
467: ,decode (p_balance_level,
468: 'ASG', (PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pbT.balance_name) ,
469: 'ASG_GRE_PTD' ,
470: NULL,
471: l_temp_assignment_id,
472: l_date,

Line 477: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

473: p_tax_unit_id,
474: p_business_group_id ,
475: NULL)),
476: 'PER', NULL) PTD_VAL
477: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
478: l_dim_month,
479: NULL ,
480: l_temp_assignment_id,
481: l_date ,

Line 485: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

481: l_date ,
482: p_tax_unit_id,
483: p_business_group_id ,
484: NULL) MONTH_VAL
485: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
486: l_dim_qtd,
487: NULL ,
488: l_temp_assignment_id,
489: nvl(l_qtd_date,l_date ),

Line 493: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,

489: nvl(l_qtd_date,l_date ),
490: p_tax_unit_id,
491: p_business_group_id ,
492: NULL) QTD_VAL
493: ,PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM (UPPER(pBT.balance_name) ,
494: l_dim_ytd,
495: NULL ,--global.assignment_action_id
496: l_temp_assignment_id,
497: nvl(l_ytd_date,l_date) ,

Line 863: * PAY_US_TAXBAL_VIEW_PKG

859: /******************************************************************************
860: * Name : get_asg_date
861: * Purpose : This procedure is used to get the correct assignment and date
862: * that have to be passed in the call to the package
863: * PAY_US_TAXBAL_VIEW_PKG
864: ******************************************************************************/
865: PROCEDURE get_asg_date IS
866: l_procedure varchar2(14);
867: BEGIN

Line 1183: p_dedn_data(i).accrued := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1179: END LOOP;
1180:
1181: FOR I IN 0 .. P_DEDN_DATA.COUNt-1
1182: LOOP
1183: p_dedn_data(i).accrued := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1184: (UPPER(p_dedn_data_temp(i).accrued) ,
1185: 'ASG_GRE_ITD' ,
1186: p_assignment_action_id ,
1187: NULL,

Line 1192: p_dedn_data(i).arrears := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1188: NULL ,
1189: p_tax_unit_id,
1190: p_business_group_id ,
1191: NULL) ;
1192: p_dedn_data(i).arrears := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1193: (UPPER(p_dedn_data_temp(i).arrears) ,
1194: 'ASG_GRE_ITD' ,
1195: p_assignment_action_id ,
1196: NULL,

Line 1201: p_dedn_data(i).tobond := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1197: NULL ,
1198: p_tax_unit_id,
1199: p_business_group_id ,
1200: NULL) ;
1201: p_dedn_data(i).tobond := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1202: (UPPER(p_dedn_data_temp(i).tobond) ,
1203: 'ASG_GRE_ITD' ,
1204: p_assignment_action_id ,
1205: NULL,

Line 1495: p_dedn_data(i).accrued := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1491: p_dedn_data_temp(i).tobond :=get_balance_name(p_dedn_data(i).element_information14);
1492: END LOOP;
1493:
1494: FOR I IN 0 .. P_DEDN_DATA.COUNt-1 LOOP
1495: p_dedn_data(i).accrued := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1496: (UPPER(p_dedn_data_temp(i).accrued) ,
1497: 'ASG_GRE_ITD' ,
1498: NULL ,
1499: l_temp_assignment_id,

Line 1504: p_dedn_data(i).arrears := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1500: l_date ,
1501: p_tax_unit_id,
1502: p_business_group_id ,
1503: NULL) ;
1504: p_dedn_data(i).arrears := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1505: (UPPER(p_dedn_data_temp(i).arrears) ,
1506: 'ASG_GRE_ITD' ,
1507: NULL ,
1508: l_temp_assignment_id,

Line 1513: p_dedn_data(i).tobond := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM

1509: l_date ,
1510: p_tax_unit_id,
1511: p_business_group_id ,
1512: NULL) ;
1513: p_dedn_data(i).tobond := PAY_US_TAXBAL_VIEW_PKG.US_NAMED_BALANCE_VM
1514: (UPPER(p_dedn_data_temp(i).tobond) ,
1515: 'ASG_GRE_ITD' ,
1516: NULL ,
1517: l_temp_assignment_id,