469: l_asg_balance_time,
470: l_asg_vdate_cursor);
471: --
472: l_balance_value := l_balance_value +
473: pay_balance_pkg.get_value_lock
474: (l_defined_balance_id,
475: l_asg_id,
476: l_virtual_date,
477: l_run_route_bool,
488: --
489: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 50);
490: l_defined_balance_id := get_defined_balance(p_balance_name,
491: p_database_suffix);
492: l_balance_value := pay_balance_pkg.get_value_lock
493: (l_defined_balance_id,
494: p_assignment_id,
495: p_virtual_date,
496: l_run_route_bool,
504: --
505: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_asg_value', 60);
506: l_defined_balance_id := get_defined_balance(p_balance_name,
507: p_database_suffix);
508: l_balance_value := pay_balance_pkg.get_value_lock
509: (l_defined_balance_id,
510: p_assignment_id,
511: p_virtual_date,
512: l_run_route_bool,
561: hr_utility.set_location('pay_us_tax_bals_pkg.get_grp_act_value', 10);
562: --
563: l_defined_balance_id := get_defined_balance(p_balance_name,
564: p_database_suffix);
565: l_balance_value := pay_balance_pkg.get_value (l_defined_balance_id,
566: p_assignment_action_id,
567: l_run_route_bool,
568: FALSE
569: );
682: l_defined_balance_id := get_defined_balance(p_balance_name,
683: p_dimension_suffix);
684: IF p_dimension_suffix not like '%PAY%' THEN
685: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 30);
686: return pay_balance_pkg.get_value (l_defined_balance_id,
687: p_assignment_action_id,
688: l_run_route_bool,
689: FALSE
690: );
689: FALSE
690: );
691: ELSE /* If payments dimension then must execute DB item 395029 */
692: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit', 40);
693: return pay_balance_pkg.get_value (l_defined_balance_id,
694: p_assignment_action_id,
695: true );
696: -- END IF;
697: end if;
718: l_defined_balance_id := get_defined_balance(p_balance_name,
719: p_dimension_suffix);
720: hr_utility.set_location('pay_us_tax_bals_pkg.call_balance_user_exit',
721: 60);
722: return pay_balance_pkg.get_value_lock
723: (l_defined_balance_id,
724: p_assignment_id,
725: p_virtual_date,
726: l_run_route_bool,
1003: -- them up front
1004: --
1005: hr_utility.set_location('pay_tax_bals_pkg',30);
1006: --
1007: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1008: IF p_jd_context IS NOT NULL THEN
1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));
1006: --
1007: pay_balance_pkg.set_context('TAX_UNIT_ID',p_gre_id_context);
1008: IF p_jd_context IS NOT NULL THEN
1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));
1012: ELSE
1013: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1014: END IF;
1009: IF (p_tax_type = 'SCHOOL' and length(p_jd_context) > 11) THEN
1010: pay_balance_pkg.set_context('JURISDICTION_CODE',substr(p_jd_context,1,2)||
1011: '-'||substr(p_jd_context,13,5));
1012: ELSE
1013: pay_balance_pkg.set_context('JURISDICTION_CODE',p_jd_context);
1014: END IF;
1015: END IF;
1016: --
1017: hr_utility.set_location('pay_tax_bals_pkg',40);
1249: l_count number;
1250: l_found boolean;
1251: check_asg number;
1252: begin
1253: pay_balance_pkg.set_context('DATE_EARNED',
1254: fnd_date.date_to_canonical(l_virtual_date));
1255: pay_balance_pkg.set_context('BALANCE_DATE',
1256: fnd_date.date_to_canonical(l_virtual_date));
1257: select business_group_id
1251: check_asg number;
1252: begin
1253: pay_balance_pkg.set_context('DATE_EARNED',
1254: fnd_date.date_to_canonical(l_virtual_date));
1255: pay_balance_pkg.set_context('BALANCE_DATE',
1256: fnd_date.date_to_canonical(l_virtual_date));
1257: select business_group_id
1258: into l_bg_id
1259: from hr_organization_units