eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_EOY_ARCHIVE dependencies on PAY_CA_BALANCE_PKG

Line 1049: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1045: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
1046: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',ln_max_aa_id);
1047:
1048: ln_non_taxable_earnings :=
1049: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1050: ('T4 Non Taxable Earnings',
1051: 'YTD',ln_max_aa_id,l_primary_asg,NULL,'PER',
1052: l_tax_unit_id,l_bus_group_id,NULL),0);
1053: hr_utility.trace('T4 Non Taxable Earnings :'||

Line 1057: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1053: hr_utility.trace('T4 Non Taxable Earnings :'||
1054: to_char(ln_non_taxable_earnings));
1055:
1056: ln_gross_earnings :=
1057: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1058: ('Gross Earnings',
1059: 'YTD',ln_max_aa_id,l_primary_asg,NULL,'PER' ,
1060:
1061: l_tax_unit_id, l_bus_group_id, NULL),0);

Line 1066: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

1062: hr_utility.trace('Gross Earnings :'||
1063: to_char(ln_gross_earnings));
1064:
1065: ln_no_gross_earnings :=
1066: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
1067: ('T4 No Gross Earnings',
1068: 'YTD',ln_max_aa_id, l_primary_asg,NULL,'PER' ,
1069: l_tax_unit_id, l_bus_group_id, NULL),0);
1070: hr_utility.trace('T4 No Gross Earnings :'||

Line 3007: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3003: l_balance_type_tab(l_count) := 'CPP Exempt';
3004:
3005:
3006: ln_non_taxable_earnings :=
3007: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3008: ('T4 Non Taxable Earnings',
3009: 'YTD',l_aaid,l_asgid,NULL,'PER',
3010: l_tax_unit_id,l_business_group_id,l_jurisdiction),0);
3011:

Line 3013: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3009: 'YTD',l_aaid,l_asgid,NULL,'PER',
3010: l_tax_unit_id,l_business_group_id,l_jurisdiction),0);
3011:
3012: ln_gross_earnings :=
3013: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3014: ('Gross Earnings',
3015: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
3016: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
3017:

Line 3019: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3015: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
3016: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
3017:
3018: ln_no_gross_earnings :=
3019: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3020: ('T4 No Gross Earnings',
3021: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
3022: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
3023:

Line 3028: nvl(pay_ca_balance_pkg.call_ca_balance_get_value

3024: /* Modification for bug 13087530 starts here. */
3025:
3026: IF ( to_number(to_char(l_year_end,'YYYY')) >= 2012) then
3027: ln_taxben_without_remuneration :=
3028: nvl(pay_ca_balance_pkg.call_ca_balance_get_value
3029: ('Taxable Benefit without Remuneration',
3030: 'YTD' , l_aaid, l_asgid , NULL, 'PER' ,
3031: l_tax_unit_id, l_business_group_id, l_jurisdiction),0);
3032:

Line 3062: result := pay_ca_balance_pkg.call_ca_balance_get_value

3058:
3059: for i in 1 .. l_count
3060: loop
3061:
3062: result := pay_ca_balance_pkg.call_ca_balance_get_value
3063: ( l_balance_type_tab(i),
3064: 'YTD' ,
3065: l_aaid,
3066: l_asgid ,

Line 3146: qc_result := pay_ca_balance_pkg.call_ca_balance_get_value

3142: hr_utility.trace('l_tax_unit_id ' || to_char(l_tax_unit_id));
3143: hr_utility.trace('l_business_group_id '||to_char(l_business_group_id));
3144: hr_utility.trace('l_jurisdiction ' || l_jurisdiction);
3145:
3146: qc_result := pay_ca_balance_pkg.call_ca_balance_get_value
3147: ( 'Taxable Benefits for Quebec',
3148: 'YTD' ,
3149: l_aaid,
3150: l_asgid ,

Line 3170: other_info_amount31 := pay_ca_balance_pkg.call_ca_balance_get_value

3166: end if;
3167:
3168: if l_balance_type_tab(i) = 'Gross Earnings' then
3169:
3170: other_info_amount31 := pay_ca_balance_pkg.call_ca_balance_get_value
3171: ( 'T4_OTHER_INFO_AMOUNT31',
3172: 'YTD' ,
3173: l_aaid,
3174: l_asgid ,

Line 3184: other_info_amount53 := pay_ca_balance_pkg.call_ca_balance_get_value

3180: ) ;
3181:
3182: /* Modification for bug 10244185 starts here. */
3183: IF ( to_number(to_char(l_year_end,'YYYY')) < 2011) then
3184: other_info_amount53 := pay_ca_balance_pkg.call_ca_balance_get_value
3185: ( 'T4_OTHER_INFO_AMOUNT53',
3186: 'YTD' ,
3187: l_aaid,
3188: l_asgid ,

Line 3201: other_info_amount78 := pay_ca_balance_pkg.call_ca_balance_get_value

3197: /* Modification for bug 10244185 ends here. */
3198:
3199: /* Added by ssmukher for Bug 4547415 */
3200:
3201: other_info_amount78 := pay_ca_balance_pkg.call_ca_balance_get_value
3202: ( 'T4_OTHER_INFO_AMOUNT78',
3203: 'YTD' ,
3204: l_aaid,
3205: l_asgid ,

Line 3214: other_info_amount71 := pay_ca_balance_pkg.call_ca_balance_get_value

3210: l_jurisdiction
3211: ) ;
3212:
3213:
3214: other_info_amount71 := pay_ca_balance_pkg.call_ca_balance_get_value
3215: ( 'T4_OTHER_INFO_AMOUNT71',
3216: 'YTD' ,
3217: l_aaid,
3218: l_asgid ,

Line 3229: other_info_amount81 := pay_ca_balance_pkg.call_ca_balance_get_value

3225:
3226: -- code started for bug 5698016
3227:
3228:
3229: other_info_amount81 := pay_ca_balance_pkg.call_ca_balance_get_value
3230: ( 'T4_OTHER_INFO_AMOUNT81',
3231: 'YTD' ,
3232: l_aaid,
3233: l_asgid ,

Line 3241: other_info_amount82 := pay_ca_balance_pkg.call_ca_balance_get_value

3237: l_business_group_id,
3238: l_jurisdiction
3239: ) ;
3240:
3241: other_info_amount82 := pay_ca_balance_pkg.call_ca_balance_get_value
3242: ( 'T4_OTHER_INFO_AMOUNT82',
3243: 'YTD' ,
3244: l_aaid,
3245: l_asgid ,

Line 3253: other_info_amount83 := pay_ca_balance_pkg.call_ca_balance_get_value

3249: l_business_group_id,
3250: l_jurisdiction
3251: ) ;
3252:
3253: other_info_amount83 := pay_ca_balance_pkg.call_ca_balance_get_value
3254: ( 'T4_OTHER_INFO_AMOUNT83',
3255: 'YTD' ,
3256: l_aaid,
3257: l_asgid ,

Line 3266: other_info_amount84 := pay_ca_balance_pkg.call_ca_balance_get_value

3262: l_jurisdiction
3263: ) ;
3264:
3265: /*
3266: other_info_amount84 := pay_ca_balance_pkg.call_ca_balance_get_value
3267: ( 'T4_OTHER_INFO_AMOUNT84',
3268: 'YTD' ,
3269: l_aaid,
3270: l_asgid ,

Line 3278: other_info_amount85 := pay_ca_balance_pkg.call_ca_balance_get_value

3274: l_business_group_id,
3275: l_jurisdiction
3276: ) ;
3277:
3278: other_info_amount85 := pay_ca_balance_pkg.call_ca_balance_get_value
3279: ( 'T4_OTHER_INFO_AMOUNT85',
3280: 'YTD' ,
3281: l_aaid,
3282: l_asgid ,

Line 3294: other_info_amount66 := pay_ca_balance_pkg.call_ca_balance_get_value

3290: -- code ended for bug 5698016
3291:
3292: -- code ended for bug 9135405
3293: IF ( to_number(to_char(l_year_end,'YYYY')) >= 2010) then
3294: other_info_amount66 := pay_ca_balance_pkg.call_ca_balance_get_value
3295: ( 'T4_OTHER_INFO_AMOUNT66',
3296: 'YTD' ,
3297: l_aaid,
3298: l_asgid ,

Line 3306: other_info_amount67 := pay_ca_balance_pkg.call_ca_balance_get_value

3302: l_business_group_id,
3303: l_jurisdiction
3304: ) ;
3305:
3306: other_info_amount67 := pay_ca_balance_pkg.call_ca_balance_get_value
3307: ( 'T4_OTHER_INFO_AMOUNT67',
3308: 'YTD' ,
3309: l_aaid,
3310: l_asgid ,

Line 3318: other_info_amount68 := pay_ca_balance_pkg.call_ca_balance_get_value

3314: l_business_group_id,
3315: l_jurisdiction
3316: ) ;
3317:
3318: other_info_amount68 := pay_ca_balance_pkg.call_ca_balance_get_value
3319: ( 'T4_OTHER_INFO_AMOUNT68',
3320: 'YTD' ,
3321: l_aaid,
3322: l_asgid ,

Line 3330: other_info_amount69 := pay_ca_balance_pkg.call_ca_balance_get_value

3326: l_business_group_id,
3327: l_jurisdiction
3328: ) ;
3329:
3330: other_info_amount69 := pay_ca_balance_pkg.call_ca_balance_get_value
3331: ( 'T4_OTHER_INFO_AMOUNT69',
3332: 'YTD' ,
3333: l_aaid,
3334: l_asgid ,

Line 3346: other_info_amount87 := pay_ca_balance_pkg.call_ca_balance_get_value

3342: -- code ended for bug 9135405
3343:
3344: -- code starts for bug 10244185
3345: IF ( to_number(to_char(l_year_end,'YYYY')) >= 2011) then
3346: other_info_amount87 := pay_ca_balance_pkg.call_ca_balance_get_value
3347: ( 'T4_OTHER_INFO_AMOUNT87',
3348: 'YTD' ,
3349: l_aaid,
3350: l_asgid ,

Line 3963: l_value := pay_ca_balance_pkg.call_ca_balance_get_value

3959:
3960: -- if condition added by sneelapa for bug 6399498
3961: if fnd_number.canonical_to_number(l_screen_entry_value) >= 0 then
3962:
3963: l_value := pay_ca_balance_pkg.call_ca_balance_get_value
3964: ( l_balance_name,
3965: 'YTD' ,
3966: l_aaid,
3967: l_asgid,