DBA Data[Home] [Help]

APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on HR_DIRBAL

Line 333: C_GROSS_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

329: L_PERIOD_FLAG := 'Y';
330: END IF;
331: C_GROSS_PAY_PTD_VALUE := 0;
332: C_GROSS_PAY_YTD_VALUE := 0;
333: C_GROSS_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
334: ,C_GROSS_PAY_YTD_DBID);
335: IF L_PERIOD_FLAG = 'N' THEN
336: C_GROSS_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
337: ,C_GROSS_PAY_PTD_DBID);

Line 336: C_GROSS_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

332: C_GROSS_PAY_YTD_VALUE := 0;
333: C_GROSS_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
334: ,C_GROSS_PAY_YTD_DBID);
335: IF L_PERIOD_FLAG = 'N' THEN
336: C_GROSS_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
337: ,C_GROSS_PAY_PTD_DBID);
338: END IF;
339: C_GROSS_PAY_PTD_TOT := C_GROSS_PAY_PTD_TOT + C_GROSS_PAY_PTD_VALUE;
340: C_GROSS_PAY_YTD_TOT := C_GROSS_PAY_YTD_TOT + C_GROSS_PAY_YTD_VALUE;

Line 343: C_TAXABLE_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

339: C_GROSS_PAY_PTD_TOT := C_GROSS_PAY_PTD_TOT + C_GROSS_PAY_PTD_VALUE;
340: C_GROSS_PAY_YTD_TOT := C_GROSS_PAY_YTD_TOT + C_GROSS_PAY_YTD_VALUE;
341: C_TAXABLE_PAY_PTD_VALUE := 0;
342: C_TAXABLE_PAY_YTD_VALUE := 0;
343: C_TAXABLE_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
344: ,C_TAXABLE_PAY_YTD_DBID);
345: IF L_PERIOD_FLAG = 'N' THEN
346: C_TAXABLE_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
347: ,C_TAXABLE_PAY_PTD_DBID);

Line 346: C_TAXABLE_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

342: C_TAXABLE_PAY_YTD_VALUE := 0;
343: C_TAXABLE_PAY_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
344: ,C_TAXABLE_PAY_YTD_DBID);
345: IF L_PERIOD_FLAG = 'N' THEN
346: C_TAXABLE_PAY_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
347: ,C_TAXABLE_PAY_PTD_DBID);
348: END IF;
349: C_TAXABLE_PAY_PTD_TOT := C_TAXABLE_PAY_PTD_TOT + C_TAXABLE_PAY_PTD_VALUE;
350: C_TAXABLE_PAY_YTD_TOT := C_TAXABLE_PAY_YTD_TOT + C_TAXABLE_PAY_YTD_VALUE;

Line 353: C_PENSION_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

349: C_TAXABLE_PAY_PTD_TOT := C_TAXABLE_PAY_PTD_TOT + C_TAXABLE_PAY_PTD_VALUE;
350: C_TAXABLE_PAY_YTD_TOT := C_TAXABLE_PAY_YTD_TOT + C_TAXABLE_PAY_YTD_VALUE;
351: C_PENSION_PTD_VALUE := 0;
352: C_PENSION_YTD_VALUE := 0;
353: C_PENSION_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
354: ,C_PENSION_YTD_DBID);
355: IF L_PERIOD_FLAG = 'N' THEN
356: C_PENSION_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
357: ,C_PENSION_PTD_DBID);

Line 356: C_PENSION_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

352: C_PENSION_YTD_VALUE := 0;
353: C_PENSION_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
354: ,C_PENSION_YTD_DBID);
355: IF L_PERIOD_FLAG = 'N' THEN
356: C_PENSION_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
357: ,C_PENSION_PTD_DBID);
358: END IF;
359: C_PAYE_PTD_VALUE := 0;
360: C_PAYE_YTD_VALUE := 0;

Line 361: C_PAYE_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

357: ,C_PENSION_PTD_DBID);
358: END IF;
359: C_PAYE_PTD_VALUE := 0;
360: C_PAYE_YTD_VALUE := 0;
361: C_PAYE_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
362: ,C_PAYE_YTD_DBID);
363: IF L_PERIOD_FLAG = 'N' THEN
364: C_PAYE_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
365: ,C_PAYE_PTD_DBID);

Line 364: C_PAYE_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

360: C_PAYE_YTD_VALUE := 0;
361: C_PAYE_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
362: ,C_PAYE_YTD_DBID);
363: IF L_PERIOD_FLAG = 'N' THEN
364: C_PAYE_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
365: ,C_PAYE_PTD_DBID);
366: END IF;
367: C_PAYE_PTD_TOT := C_PAYE_PTD_TOT + C_PAYE_PTD_VALUE;
368: C_PAYE_YTD_TOT := C_PAYE_YTD_TOT + C_PAYE_YTD_VALUE;

Line 371: C_SSP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

367: C_PAYE_PTD_TOT := C_PAYE_PTD_TOT + C_PAYE_PTD_VALUE;
368: C_PAYE_YTD_TOT := C_PAYE_YTD_TOT + C_PAYE_YTD_VALUE;
369: C_SSP_PTD_VALUE := 0;
370: C_SSP_YTD_VALUE := 0;
371: C_SSP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
372: ,C_SSP_YTD_DBID);
373: IF L_PERIOD_FLAG = 'N' THEN
374: C_SSP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
375: ,C_SSP_PTD_DBID);

Line 374: C_SSP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

370: C_SSP_YTD_VALUE := 0;
371: C_SSP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
372: ,C_SSP_YTD_DBID);
373: IF L_PERIOD_FLAG = 'N' THEN
374: C_SSP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
375: ,C_SSP_PTD_DBID);
376: END IF;
377: C_SSP_PTD_TOT := C_SSP_PTD_TOT + C_SSP_PTD_VALUE;
378: C_SSP_YTD_TOT := C_SSP_YTD_TOT + C_SSP_YTD_VALUE;

Line 381: C_SMP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

377: C_SSP_PTD_TOT := C_SSP_PTD_TOT + C_SSP_PTD_VALUE;
378: C_SSP_YTD_TOT := C_SSP_YTD_TOT + C_SSP_YTD_VALUE;
379: C_SMP_PTD_VALUE := 0;
380: C_SMP_YTD_VALUE := 0;
381: C_SMP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
382: ,C_SMP_YTD_DBID);
383: IF L_PERIOD_FLAG = 'N' THEN
384: C_SMP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
385: ,C_SMP_PTD_DBID);

Line 384: C_SMP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

380: C_SMP_YTD_VALUE := 0;
381: C_SMP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
382: ,C_SMP_YTD_DBID);
383: IF L_PERIOD_FLAG = 'N' THEN
384: C_SMP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
385: ,C_SMP_PTD_DBID);
386: END IF;
387: C_SMP_PTD_TOT := C_SMP_PTD_TOT + C_SMP_PTD_VALUE;
388: C_SMP_YTD_TOT := C_SMP_YTD_TOT + C_SMP_YTD_VALUE;

Line 391: C_SAP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

387: C_SMP_PTD_TOT := C_SMP_PTD_TOT + C_SMP_PTD_VALUE;
388: C_SMP_YTD_TOT := C_SMP_YTD_TOT + C_SMP_YTD_VALUE;
389: C_SAP_PTD_VALUE := 0;
390: C_SAP_YTD_VALUE := 0;
391: C_SAP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
392: ,C_SAP_YTD_DBID);
393: C_SAP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
394: ,C_SAP_PTD_DBID);
395: C_SAP_PTD_TOT := C_SAP_PTD_TOT + C_SAP_PTD_VALUE;

Line 393: C_SAP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

389: C_SAP_PTD_VALUE := 0;
390: C_SAP_YTD_VALUE := 0;
391: C_SAP_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
392: ,C_SAP_YTD_DBID);
393: C_SAP_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
394: ,C_SAP_PTD_DBID);
395: C_SAP_PTD_TOT := C_SAP_PTD_TOT + C_SAP_PTD_VALUE;
396: C_SAP_YTD_TOT := C_SAP_YTD_TOT + C_SAP_YTD_VALUE;
397: C_SPPA_PTD_VALUE := 0;

Line 399: C_SPPA_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

395: C_SAP_PTD_TOT := C_SAP_PTD_TOT + C_SAP_PTD_VALUE;
396: C_SAP_YTD_TOT := C_SAP_YTD_TOT + C_SAP_YTD_VALUE;
397: C_SPPA_PTD_VALUE := 0;
398: C_SPPA_YTD_VALUE := 0;
399: C_SPPA_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
400: ,C_SPPA_YTD_DBID);
401: IF L_PERIOD_FLAG = 'N' THEN
402: C_SPPA_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
403: ,C_SPPA_PTD_DBID);

Line 402: C_SPPA_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

398: C_SPPA_YTD_VALUE := 0;
399: C_SPPA_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
400: ,C_SPPA_YTD_DBID);
401: IF L_PERIOD_FLAG = 'N' THEN
402: C_SPPA_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
403: ,C_SPPA_PTD_DBID);
404: END IF;
405: C_SPPA_PTD_TOT := C_SPPA_PTD_TOT + C_SPPA_PTD_VALUE;
406: C_SPPA_YTD_TOT := C_SPPA_YTD_TOT + C_SPPA_YTD_VALUE;

Line 409: C_SPPB_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

405: C_SPPA_PTD_TOT := C_SPPA_PTD_TOT + C_SPPA_PTD_VALUE;
406: C_SPPA_YTD_TOT := C_SPPA_YTD_TOT + C_SPPA_YTD_VALUE;
407: C_SPPB_PTD_VALUE := 0;
408: C_SPPB_YTD_VALUE := 0;
409: C_SPPB_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
410: ,C_SPPB_YTD_DBID);
411: IF L_PERIOD_FLAG = 'N' THEN
412: C_SPPB_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
413: ,C_SPPB_PTD_DBID);

Line 412: C_SPPB_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

408: C_SPPB_YTD_VALUE := 0;
409: C_SPPB_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
410: ,C_SPPB_YTD_DBID);
411: IF L_PERIOD_FLAG = 'N' THEN
412: C_SPPB_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
413: ,C_SPPB_PTD_DBID);
414: END IF;
415: C_SPPB_PTD_TOT := C_SPPB_PTD_TOT + C_SPPB_PTD_VALUE;
416: C_SPPB_YTD_TOT := C_SPPB_YTD_TOT + C_SPPB_YTD_VALUE;

Line 419: C_STULN_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

415: C_SPPB_PTD_TOT := C_SPPB_PTD_TOT + C_SPPB_PTD_VALUE;
416: C_SPPB_YTD_TOT := C_SPPB_YTD_TOT + C_SPPB_YTD_VALUE;
417: C_STULN_PTD_VALUE := 0;
418: C_STULN_YTD_VALUE := 0;
419: C_STULN_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
420: ,C_STULN_YTD_DBID);
421: IF L_PERIOD_FLAG = 'N' THEN
422: C_STULN_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
423: ,C_STULN_PTD_DBID);

Line 422: C_STULN_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

418: C_STULN_YTD_VALUE := 0;
419: C_STULN_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
420: ,C_STULN_YTD_DBID);
421: IF L_PERIOD_FLAG = 'N' THEN
422: C_STULN_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
423: ,C_STULN_PTD_DBID);
424: END IF;
425: C_STULN_PTD_TOT := C_STULN_PTD_TOT + C_STULN_PTD_VALUE;
426: C_STULN_YTD_TOT := C_STULN_YTD_TOT + C_STULN_YTD_VALUE;

Line 429: C_WORKING_TAXCR_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

425: C_STULN_PTD_TOT := C_STULN_PTD_TOT + C_STULN_PTD_VALUE;
426: C_STULN_YTD_TOT := C_STULN_YTD_TOT + C_STULN_YTD_VALUE;
427: C_WORKING_TAXCR_PTD_VALUE := 0;
428: C_WORKING_TAXCR_YTD_VALUE := 0;
429: C_WORKING_TAXCR_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
430: ,C_WORKING_TAXCR_YTD_DBID);
431: IF L_PERIOD_FLAG = 'N' THEN
432: C_WORKING_TAXCR_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
433: ,C_WORKING_TAXCR_PTD_DBID);

Line 432: C_WORKING_TAXCR_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID

428: C_WORKING_TAXCR_YTD_VALUE := 0;
429: C_WORKING_TAXCR_YTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
430: ,C_WORKING_TAXCR_YTD_DBID);
431: IF L_PERIOD_FLAG = 'N' THEN
432: C_WORKING_TAXCR_PTD_VALUE := HR_DIRBAL.GET_BALANCE(ASG_ACTION_ID
433: ,C_WORKING_TAXCR_PTD_DBID);
434: END IF;
435: RETURN (0);
436: END C_GET_BALANCESFORMULA;