APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 891: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

887: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
888: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
889:
890: ln_non_taxable_earnings :=
891: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
892: ('T4 Non Taxable Earnings',
893: 'YTD',ln_max_aa_id,l_primary_asg,NULL,'PER',
894: l_tax_unit_id,l_bus_group_id,NULL),0);
895: hr_utility.trace('T4 Non Taxable Earnings :'||

Line 899: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

895: hr_utility.trace('T4 Non Taxable Earnings :'||
896: to_char(ln_non_taxable_earnings));
897:
898: ln_gross_earnings :=
899: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
900: ('Gross Earnings',
901: 'YTD',ln_max_aa_id,l_primary_asg,NULL,'PER' ,
902:
903: l_tax_unit_id, l_bus_group_id, NULL),0);

Line 908: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

904: hr_utility.trace('Gross Earnings :'||
905: to_char(ln_gross_earnings));
906:
907: ln_no_gross_earnings :=
908: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
909: ('T4 No Gross Earnings',
910: 'YTD',ln_max_aa_id, l_primary_asg,NULL,'PER' ,
911: l_tax_unit_id, l_bus_group_id, NULL),0);
912: hr_utility.trace('T4 No Gross Earnings :'||

Line 2651: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2647: l_balance_type_tab(l_count) := 'CPP Exempt';
2648:
2649:
2650: ln_non_taxable_earnings :=
2651: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2652: ('T4 Non Taxable Earnings',
2653: 'YTD',l_aaid,l_asgid,NULL,'PER',
2654: l_tax_unit_id,l_business_group_id,l_jurisdiction),0);
2655:

Line 2657: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2653: 'YTD',l_aaid,l_asgid,NULL,'PER',
2654: l_tax_unit_id,l_business_group_id,l_jurisdiction),0);
2655:
2656: ln_gross_earnings :=
2657: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2658: ('Gross Earnings',
2659: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
2660: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
2661:

Line 2663: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

2659: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
2660: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
2661:
2662: ln_no_gross_earnings :=
2663: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
2664: ('T4 No Gross Earnings',
2665: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
2666: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
2667:

Line 2691: result := pay_ca_balance_pkg.call_ca_balance_get_value

2687: );
2688:
2689: for i in 1 .. l_count
2690: loop
2691: result := pay_ca_balance_pkg.call_ca_balance_get_value
2692: ( l_balance_type_tab(i),
2693: 'YTD' ,
2694: l_aaid,
2695: l_asgid ,

Line 2752: qc_result := pay_ca_balance_pkg.call_ca_balance_get_value

2748: hr_utility.trace('l_tax_unit_id ' || to_char(l_tax_unit_id));
2749: hr_utility.trace('l_business_group_id '||to_char(l_business_group_id));
2750: hr_utility.trace('l_jurisdiction ' || l_jurisdiction);
2751:
2752: qc_result := pay_ca_balance_pkg.call_ca_balance_get_value
2753: ( 'Taxable Benefits for Quebec',
2754: 'YTD' ,
2755: l_aaid,
2756: l_asgid ,

Line 2776: other_info_amount31 := pay_ca_balance_pkg.call_ca_balance_get_value

2772: end if;
2773:
2774: if l_balance_type_tab(i) = 'Gross Earnings' then
2775:
2776: other_info_amount31 := pay_ca_balance_pkg.call_ca_balance_get_value
2777: ( 'T4_OTHER_INFO_AMOUNT31',
2778: 'YTD' ,
2779: l_aaid,
2780: l_asgid ,

Line 2788: other_info_amount53 := pay_ca_balance_pkg.call_ca_balance_get_value

2784: l_business_group_id,
2785: l_jurisdiction
2786: ) ;
2787:
2788: other_info_amount53 := pay_ca_balance_pkg.call_ca_balance_get_value
2789: ( 'T4_OTHER_INFO_AMOUNT53',
2790: 'YTD' ,
2791: l_aaid,
2792: l_asgid ,

Line 2802: other_info_amount78 := pay_ca_balance_pkg.call_ca_balance_get_value

2798: ) ;
2799:
2800: /* Added by ssmukher for Bug 4547415 */
2801:
2802: other_info_amount78 := pay_ca_balance_pkg.call_ca_balance_get_value
2803: ( 'T4_OTHER_INFO_AMOUNT78',
2804: 'YTD' ,
2805: l_aaid,
2806: l_asgid ,

Line 2815: other_info_amount71 := pay_ca_balance_pkg.call_ca_balance_get_value

2811: l_jurisdiction
2812: ) ;
2813:
2814:
2815: other_info_amount71 := pay_ca_balance_pkg.call_ca_balance_get_value
2816: ( 'T4_OTHER_INFO_AMOUNT71',
2817: 'YTD' ,
2818: l_aaid,
2819: l_asgid ,

Line 2830: other_info_amount81 := pay_ca_balance_pkg.call_ca_balance_get_value

2826:
2827: -- code started for bug 5698016
2828:
2829:
2830: other_info_amount81 := pay_ca_balance_pkg.call_ca_balance_get_value
2831: ( 'T4_OTHER_INFO_AMOUNT81',
2832: 'YTD' ,
2833: l_aaid,
2834: l_asgid ,

Line 2842: other_info_amount82 := pay_ca_balance_pkg.call_ca_balance_get_value

2838: l_business_group_id,
2839: l_jurisdiction
2840: ) ;
2841:
2842: other_info_amount82 := pay_ca_balance_pkg.call_ca_balance_get_value
2843: ( 'T4_OTHER_INFO_AMOUNT82',
2844: 'YTD' ,
2845: l_aaid,
2846: l_asgid ,

Line 2854: other_info_amount83 := pay_ca_balance_pkg.call_ca_balance_get_value

2850: l_business_group_id,
2851: l_jurisdiction
2852: ) ;
2853:
2854: other_info_amount83 := pay_ca_balance_pkg.call_ca_balance_get_value
2855: ( 'T4_OTHER_INFO_AMOUNT83',
2856: 'YTD' ,
2857: l_aaid,
2858: l_asgid ,

Line 2867: other_info_amount84 := pay_ca_balance_pkg.call_ca_balance_get_value

2863: l_jurisdiction
2864: ) ;
2865:
2866: /*
2867: other_info_amount84 := pay_ca_balance_pkg.call_ca_balance_get_value
2868: ( 'T4_OTHER_INFO_AMOUNT84',
2869: 'YTD' ,
2870: l_aaid,
2871: l_asgid ,

Line 2879: other_info_amount85 := pay_ca_balance_pkg.call_ca_balance_get_value

2875: l_business_group_id,
2876: l_jurisdiction
2877: ) ;
2878:
2879: other_info_amount85 := pay_ca_balance_pkg.call_ca_balance_get_value
2880: ( 'T4_OTHER_INFO_AMOUNT85',
2881: 'YTD' ,
2882: l_aaid,
2883: l_asgid ,

Line 3371: l_value := pay_ca_balance_pkg.call_ca_balance_get_value

3367:
3368: -- if condition added by sneelapa for bug 6399498
3369: if fnd_number.canonical_to_number(l_screen_entry_value) >= 0 then
3370:
3371: l_value := pay_ca_balance_pkg.call_ca_balance_get_value
3372: ( l_balance_name,
3373: 'YTD' ,
3374: l_aaid,
3375: l_asgid,