APPS.PAY_PAYCABPS_XMLP_PKG dependencies on PAY_CA_BALANCE_VIEW_PKG

Line 279: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

275: ,'PTD'
276: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
277: ,PAA.ASSIGNMENT_ID
278: ,NULL
279: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
280: ,PAA.TAX_UNIT_ID
281: ,PPA.BUSINESS_GROUP_ID
282: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
283: ,NULL)) REGULAR_GROSS

Line 282: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

278: ,NULL
279: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
280: ,PAA.TAX_UNIT_ID
281: ,PPA.BUSINESS_GROUP_ID
282: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
283: ,NULL)) REGULAR_GROSS
284: FROM
285: HR_LOCATIONS_ALL HL,
286: PER_ALL_PEOPLE_F PPF,

Line 392: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

388: ,'PTD'
389: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
390: ,PAA.ASSIGNMENT_ID
391: ,NULL
392: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
393: ,PAA.TAX_UNIT_ID
394: ,PPA.BUSINESS_GROUP_ID
395: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
396: ,NULL)) REGULAR_GROSS

Line 395: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

391: ,NULL
392: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
393: ,PAA.TAX_UNIT_ID
394: ,PPA.BUSINESS_GROUP_ID
395: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
396: ,NULL)) REGULAR_GROSS
397: FROM
398: HR_LOCATIONS_ALL HL,
399: PER_ALL_PEOPLE_F PPF,

Line 526: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

522: ,'PTD'
523: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
524: ,PAA.ASSIGNMENT_ID
525: ,NULL
526: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
527: ,PAA.TAX_UNIT_ID
528: ,PPA.BUSINESS_GROUP_ID
529: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
530: ,NULL)) REGULAR_HOURS,

Line 529: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

525: ,NULL
526: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
527: ,PAA.TAX_UNIT_ID
528: ,PPA.BUSINESS_GROUP_ID
529: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
530: ,NULL)) REGULAR_HOURS,
531: PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE('Regular Earnings'
532: ,'PTD'
533: ,MAX(PAA.ASSIGNMENT_ACTION_ID)

Line 536: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

532: ,'PTD'
533: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
534: ,PAA.ASSIGNMENT_ID
535: ,NULL
536: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
537: ,PAA.TAX_UNIT_ID
538: ,PPA.BUSINESS_GROUP_ID
539: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
540: ,NULL)) REGULAR_GROSS,

Line 539: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

535: ,NULL
536: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
537: ,PAA.TAX_UNIT_ID
538: ,PPA.BUSINESS_GROUP_ID
539: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
540: ,NULL)) REGULAR_GROSS,
541: ROUND(((PTP.END_DATE - PTP.START_DATE + 1) / 7)
542: ,2) WEEKS
543: FROM

Line 672: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

668: ,'PTD'
669: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
670: ,PAA.ASSIGNMENT_ID
671: ,NULL
672: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
673: ,PAA.TAX_UNIT_ID
674: ,PPA.BUSINESS_GROUP_ID
675: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
676: ,NULL)) REGULAR_HOURS,

Line 675: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

671: ,NULL
672: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
673: ,PAA.TAX_UNIT_ID
674: ,PPA.BUSINESS_GROUP_ID
675: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
676: ,NULL)) REGULAR_HOURS,
677: PAY_CA_BALANCE_PKG.CALL_CA_BALANCE_GET_VALUE('Regular Earnings'
678: ,'PTD'
679: ,MAX(PAA.ASSIGNMENT_ACTION_ID)

Line 682: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')

678: ,'PTD'
679: ,MAX(PAA.ASSIGNMENT_ACTION_ID)
680: ,PAA.ASSIGNMENT_ID
681: ,NULL
682: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
683: ,PAA.TAX_UNIT_ID
684: ,PPA.BUSINESS_GROUP_ID
685: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
686: ,NULL)) REGULAR_GROSS,

Line 685: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')

681: ,NULL
682: ,PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('REPORT_LEVEL')
683: ,PAA.TAX_UNIT_ID
684: ,PPA.BUSINESS_GROUP_ID
685: ,NVL(PAY_CA_BALANCE_VIEW_PKG.GET_SESSION_VAR('JURISDICTION_CODE')
686: ,NULL)) REGULAR_GROSS,
687: ROUND(((PTP.END_DATE - PTP.START_DATE + 1) / 7)
688: ,2) WEEKS
689: FROM