APPS.PAY_CA_ARCHIVE dependencies on PAY_BALANCE_PKG

Line 2979: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);

2975: hr_utility.trace('gres.tax_unit_id = ' || to_char(gres.tax_unit_id));
2976: hr_utility.trace('17A l_final_pay_period_start_date = ' || to_char(l_final_pay_period_start_date));
2977: hr_utility.trace('17A l_final_pay_period_end_date = ' || to_char(l_final_pay_period_end_date));
2978:
2979: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
2980:
2981: open cur_latest_aaid(l_final_pay_period_start_date,
2982: l_final_pay_period_end_date,
2983: gres.tax_unit_id);

Line 2995: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,

2991:
2992: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
2993:
2994: if l_latest_aaid is not null then
2995: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
2996: l_latest_aaid),0);
2997: end if;
2998:
2999: hr_utility.trace('Vacation Paid l_value = ' || l_value);

Line 3030: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,

3026: hr_utility.trace('Box 17A l_latest_aaid_after_term = ' ||
3027: to_char(l_latest_aaid_after_term));
3028:
3029: if l_latest_aaid_after_term is not null then
3030: l_value := l_value + NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3031: l_latest_aaid_after_term),0);
3032: end if;
3033:
3034: hr_utility.trace('ROE_BOX_17A = ' || l_value);

Line 3084: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);

3080: to_char(l_defined_balance_id));
3081:
3082: for gres in cur_17_gres(l_tax_group_id) loop
3083:
3084: pay_balance_pkg.set_context('TAX_UNIT_ID',gres.tax_unit_id);
3085:
3086: open cur_latest_aaid(l_final_pay_period_start_date,
3087: l_final_pay_period_end_date,
3088: gres.tax_unit_id);

Line 3101: NVL(pay_balance_pkg.get_value(l_defined_balance_id,

3097: hr_utility.trace('l_latest_aaid = ' || to_char(l_latest_aaid));
3098:
3099: if l_latest_aaid is not null then
3100: l_value := l_value +
3101: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3102: l_latest_aaid),0);
3103: end if;
3104:
3105: hr_utility.trace(

Line 3143: NVL(pay_balance_pkg.get_value(l_defined_balance_id,

3139: to_char(l_latest_aaid_after_term));
3140:
3141: if l_latest_aaid_after_term is not null then
3142: l_value := l_value +
3143: NVL(pay_balance_pkg.get_value(l_defined_balance_id,
3144: l_latest_aaid_after_term),0);
3145: end if;
3146:
3147: hr_utility.trace('Box 17C l_value = ' || l_value);