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.PAYUSUNB_PKG dependencies on HR_UTILITY

Line 427: hr_utility.trace('Inserting Data into pay_us_rpt_totals1');

423: IF G_asgn_action_id IS NULL OR G_asgn_action_id <> IN_asgn_action_id THEN
424:
425: -- if assignment_action_id changed then write new header record
426: G_asgn_action_id := IN_asgn_action_id;
427: hr_utility.trace('Inserting Data into pay_us_rpt_totals1');
428: INSERT INTO pay_us_rpt_totals
429: (state_code,
430: tax_unit_id,
431: organization_id,

Line 673: hr_utility.set_location('procpyr',1);

669: p_report_type => 'PAYUSUNB'
670: ,p_report_format => 'DEFAULT'
671: ,p_report_qualifier => 'DEFAULT'
672: ,p_report_category => 'REPORT');
673: hr_utility.set_location('procpyr',1);
674: if l_range_person then
675: OPEN c_actions_person_on(IN_pactid, IN_chunk);
676: else
677: OPEN c_actions(IN_stperson, IN_endperson, L_gre_id,

Line 683: hr_utility.set_location('procpyr',2);

679: L_start_date, L_as_of_date);
680: end if;
681:
682: LOOP
683: hr_utility.set_location('procpyr',2);
684: if l_range_person then
685: FETCH c_actions_person_on INTO L_person_id;
686: EXIT WHEN c_actions_person_on%NOTFOUND;
687: else

Line 700: hr_utility.trace('L_person_id = '||to_char(L_person_id));

696:
697: -- we need to insert one action for each of the
698: -- rows that we return FROM the cursor (i.e. one
699: -- for each assignment/pre-payment/reversal).
700: hr_utility.trace('L_person_id = '||to_char(L_person_id));
701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);

Line 701: hr_utility.trace('L_org_id = '||to_char(L_org_id));

697: -- we need to insert one action for each of the
698: -- rows that we return FROM the cursor (i.e. one
699: -- for each assignment/pre-payment/reversal).
700: hr_utility.trace('L_person_id = '||to_char(L_person_id));
701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);
705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));

Line 702: hr_utility.trace('L_location_id = '||to_char(L_location_id));

698: -- rows that we return FROM the cursor (i.e. one
699: -- for each assignment/pre-payment/reversal).
700: hr_utility.trace('L_person_id = '||to_char(L_person_id));
701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);
705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
706:

Line 703: hr_utility.trace('L_as_of_date = '||L_as_of_date);

699: -- for each assignment/pre-payment/reversal).
700: hr_utility.trace('L_person_id = '||to_char(L_person_id));
701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);
705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
706:
707: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,

Line 704: hr_utility.trace('L_start_date = '||L_start_date);

700: hr_utility.trace('L_person_id = '||to_char(L_person_id));
701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);
705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
706:
707: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,
708: L_start_date,L_org_id,L_location_id);

Line 705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));

701: hr_utility.trace('L_org_id = '||to_char(L_org_id));
702: hr_utility.trace('L_location_id = '||to_char(L_location_id));
703: hr_utility.trace('L_as_of_date = '||L_as_of_date);
704: hr_utility.trace('L_start_date = '||L_start_date);
705: hr_utility.trace('L_gre_id = '||to_char(L_gre_id));
706:
707: OPEN c_get_latest_asg(L_person_id,L_gre_id,L_as_of_date,
708: L_start_date,L_org_id,L_location_id);
709: FETCH c_get_latest_asg INTO L_lockedactid; /* Change for Performance Bug 6360505 */

Line 712: hr_utility.trace('L_lockedactid ' || L_lockedactid);

708: L_start_date,L_org_id,L_location_id);
709: FETCH c_get_latest_asg INTO L_lockedactid; /* Change for Performance Bug 6360505 */
710: CLOSE c_get_latest_asg;
711:
712: hr_utility.trace('L_lockedactid ' || L_lockedactid);
713: /* Change for Performance Bug 6360505 */
714: OPEN c_get_asg_details(L_lockedactid, L_gre_id, L_person_id,
715: L_as_of_date, L_start_date);
716: FETCH c_get_asg_details INTO L_assignid,L_loc_id,

Line 721: hr_utility.trace('L_assignid '||to_char(L_assignid));

717: L_organization_id,L_assignment_number;
718: CLOSE c_get_asg_details;
719: /* Change for Performance Bug 6360505 */
720:
721: hr_utility.trace('L_assignid '||to_char(L_assignid));
722: hr_utility.trace('L_assignid ' || L_assignid);
723: hr_utility.trace('L_assignment_number ' || L_assignment_number);
724: hr_utility.set_location('procpyr',3);
725:

Line 722: hr_utility.trace('L_assignid ' || L_assignid);

718: CLOSE c_get_asg_details;
719: /* Change for Performance Bug 6360505 */
720:
721: hr_utility.trace('L_assignid '||to_char(L_assignid));
722: hr_utility.trace('L_assignid ' || L_assignid);
723: hr_utility.trace('L_assignment_number ' || L_assignment_number);
724: hr_utility.set_location('procpyr',3);
725:
726: SELECT pay_assignment_actions_s.NEXTVAL

Line 723: hr_utility.trace('L_assignment_number ' || L_assignment_number);

719: /* Change for Performance Bug 6360505 */
720:
721: hr_utility.trace('L_assignid '||to_char(L_assignid));
722: hr_utility.trace('L_assignid ' || L_assignid);
723: hr_utility.trace('L_assignment_number ' || L_assignment_number);
724: hr_utility.set_location('procpyr',3);
725:
726: SELECT pay_assignment_actions_s.NEXTVAL
727: INTO L_lockingactid

Line 724: hr_utility.set_location('procpyr',3);

720:
721: hr_utility.trace('L_assignid '||to_char(L_assignid));
722: hr_utility.trace('L_assignid ' || L_assignid);
723: hr_utility.trace('L_assignment_number ' || L_assignment_number);
724: hr_utility.set_location('procpyr',3);
725:
726: SELECT pay_assignment_actions_s.NEXTVAL
727: INTO L_lockingactid
728: FROM dual;

Line 763: hr_utility.trace('Skipping the verification of Balances as Person has an Assignment opting'||

759: IF L_asg_count > 0 THEN
760:
761: IF L_lockedactid is not null then
762:
763: hr_utility.trace('Skipping the verification of Balances as Person has an Assignment opting'||
764: 'for FIT Exempt from Wage Accumulation-Manual Verification needed');
765:
766: prc_write_data(500,'U',L_lockingactid,L_gre_id,L_organization_id,
767: L_loc_id,IN_pactid,IN_chunk,L_person_id,L_assignment_number,

Line 918: --hr_utility.trace('Error: PAYUSUNB_PKG.fnc_get_parameter failed - ORA'||TO_CHAR(SQLCODE));

914: RETURN L_par_value;
915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: --hr_utility.trace('Error: PAYUSUNB_PKG.fnc_get_parameter failed - ORA'||TO_CHAR(SQLCODE));
919: RAISE;
920: END fnc_get_parameter;
921:
922: /*************************************************************************

Line 994: hr_utility.trace('Inside prc_get_balance DATE mode');

990: L_rval NUMBER := 0;
991:
992: BEGIN
993:
994: hr_utility.trace('Inside prc_get_balance DATE mode');
995: hr_utility.trace('IN_as_of_date'||IN_as_of_date);
996:
997: IF IN_mode = 'DATE' THEN
998:

Line 995: hr_utility.trace('IN_as_of_date'||IN_as_of_date);

991:
992: BEGIN
993:
994: hr_utility.trace('Inside prc_get_balance DATE mode');
995: hr_utility.trace('IN_as_of_date'||IN_as_of_date);
996:
997: IF IN_mode = 'DATE' THEN
998:
999: L_rval := pay_us_tax_bals_pkg.us_tax_balance

Line 1022: hr_utility.trace('OUT_bal'||OUT_bal);

1018: END IF;
1019:
1020: OUT_bal := L_rval;
1021:
1022: hr_utility.trace('OUT_bal'||OUT_bal);
1023:
1024: EXCEPTION
1025: WHEN NO_DATA_FOUND THEN
1026: OUT_bal := 0;

Line 1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');

1090: l_asg_balance NUMBER; --#Bug 13434213 Added l_asg_balance
1091:
1092: BEGIN
1093:
1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');
1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);

Line 1095: hr_utility.trace('Parameters passed are ');

1091:
1092: BEGIN
1093:
1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');
1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);

Line 1096: hr_utility.trace('p_balance_type : '||p_balance_type);

1092: BEGIN
1093:
1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');
1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);
1100: hr_utility.trace('p_dimension : '||p_dimension);

Line 1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);

1093:
1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');
1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);
1100: hr_utility.trace('p_dimension : '||p_dimension);
1101:

Line 1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);

1094: hr_utility.trace('Inside function get_calculated_fed_limit_tax');
1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);
1100: hr_utility.trace('p_dimension : '||p_dimension);
1101:
1102: OPEN c_get_assignment_id(p_assignment_action_id);

Line 1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);

1095: hr_utility.trace('Parameters passed are ');
1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);
1100: hr_utility.trace('p_dimension : '||p_dimension);
1101:
1102: OPEN c_get_assignment_id(p_assignment_action_id);
1103: FETCH c_get_assignment_id INTO l_assignment_id;

Line 1100: hr_utility.trace('p_dimension : '||p_dimension);

1096: hr_utility.trace('p_balance_type : '||p_balance_type);
1097: hr_utility.trace('p_assignment_action_id : '||p_assignment_action_id);
1098: hr_utility.trace('p_tax_unit_id : '||p_tax_unit_id);
1099: hr_utility.trace('p_as_of_date : '||p_as_of_date);
1100: hr_utility.trace('p_dimension : '||p_dimension);
1101:
1102: OPEN c_get_assignment_id(p_assignment_action_id);
1103: FETCH c_get_assignment_id INTO l_assignment_id;
1104: CLOSE c_get_assignment_id;

Line 1106: hr_utility.trace('l_assignment_id : '||l_assignment_id);

1102: OPEN c_get_assignment_id(p_assignment_action_id);
1103: FETCH c_get_assignment_id INTO l_assignment_id;
1104: CLOSE c_get_assignment_id;
1105:
1106: hr_utility.trace('l_assignment_id : '||l_assignment_id);
1107:
1108: OPEN c_get_federal_rates;
1109: FETCH c_get_federal_rates INTO l_effective_start_date,l_effective_end_date,
1110: l_futa_rate,l_ss_ee_rate,l_ss_er_rate,

Line 1123: hr_utility.trace('Effective Start Date : '||l_effective_start_date);

1119: WHILE (c_get_federal_rates%FOUND)
1120:
1121: LOOP
1122:
1123: hr_utility.trace('Effective Start Date : '||l_effective_start_date);
1124:
1125: OPEN c_get_all_assignment_id(l_assignment_id,p_as_of_date,p_dimension); --#Bug 13434213
1126: FETCH c_get_all_assignment_id INTO l_assignment_id;
1127: hr_utility.trace('l_assignment_id :'||l_assignment_id);

Line 1127: hr_utility.trace('l_assignment_id :'||l_assignment_id);

1123: hr_utility.trace('Effective Start Date : '||l_effective_start_date);
1124:
1125: OPEN c_get_all_assignment_id(l_assignment_id,p_as_of_date,p_dimension); --#Bug 13434213
1126: FETCH c_get_all_assignment_id INTO l_assignment_id;
1127: hr_utility.trace('l_assignment_id :'||l_assignment_id);
1128:
1129: WHILE (c_get_all_assignment_id%FOUND) --#Bug 13434213
1130: LOOP
1131: IF l_effective_end_date <= p_as_of_date THEN

Line 1138: hr_utility.trace('l_asg_balance : '||l_asg_balance);

1134: l_effective_end_date, p_dimension,
1135: p_balance_type, 'TAXABLE', p_ee_or_er,
1136: NULL,'DATE', l_asg_balance); --#Bug 13434213 changed from l_balance to l_asg_balance
1137:
1138: hr_utility.trace('l_asg_balance : '||l_asg_balance);
1139:
1140: l_balance := l_balance + l_asg_balance; --#Bug 13434213
1141:
1142: hr_utility.trace('l_balance : '||l_balance);

Line 1142: hr_utility.trace('l_balance : '||l_balance);

1138: hr_utility.trace('l_asg_balance : '||l_asg_balance);
1139:
1140: l_balance := l_balance + l_asg_balance; --#Bug 13434213
1141:
1142: hr_utility.trace('l_balance : '||l_balance);
1143:
1144: ELSE
1145:
1146: prc_get_balance(l_assignment_id, p_tax_unit_id,

Line 1151: hr_utility.trace('l_asg_balance : '||l_asg_balance);

1147: p_as_of_date, p_dimension,
1148: p_balance_type, 'TAXABLE', p_ee_or_er,
1149: NULL,'DATE', l_asg_balance); --#Bug 13434213 changed from l_balance to l_asg_balance
1150:
1151: hr_utility.trace('l_asg_balance : '||l_asg_balance);
1152:
1153: l_balance := l_balance + l_asg_balance; --#Bug 13434213
1154:
1155: hr_utility.trace('l_balance : '||l_balance);

Line 1155: hr_utility.trace('l_balance : '||l_balance);

1151: hr_utility.trace('l_asg_balance : '||l_asg_balance);
1152:
1153: l_balance := l_balance + l_asg_balance; --#Bug 13434213
1154:
1155: hr_utility.trace('l_balance : '||l_balance);
1156: END IF;
1157:
1158: FETCH c_get_all_assignment_id INTO l_assignment_id; --#Bug 13434213
1159: hr_utility.trace('l_assignment_id :'||l_assignment_id);

Line 1159: hr_utility.trace('l_assignment_id :'||l_assignment_id);

1155: hr_utility.trace('l_balance : '||l_balance);
1156: END IF;
1157:
1158: FETCH c_get_all_assignment_id INTO l_assignment_id; --#Bug 13434213
1159: hr_utility.trace('l_assignment_id :'||l_assignment_id);
1160:
1161: END LOOP;
1162: CLOSE c_get_all_assignment_id; --#Bug 13434213
1163:

Line 1186: hr_utility.trace('l_rate : '||l_rate);

1182: l_rate := l_medi_er_rate;
1183:
1184: END IF;
1185:
1186: hr_utility.trace('l_rate : '||l_rate);
1187: hr_utility.trace('l_balance : '||l_balance);
1188: hr_utility.trace('l_previous_balance : '||l_previous_balance);
1189:
1190: IF p_dimension = 'QTD' THEN

Line 1187: hr_utility.trace('l_balance : '||l_balance);

1183:
1184: END IF;
1185:
1186: hr_utility.trace('l_rate : '||l_rate);
1187: hr_utility.trace('l_balance : '||l_balance);
1188: hr_utility.trace('l_previous_balance : '||l_previous_balance);
1189:
1190: IF p_dimension = 'QTD' THEN
1191: l_calculated := l_calculated + (l_balance - l_previous_balance) * l_rate;

Line 1188: hr_utility.trace('l_previous_balance : '||l_previous_balance);

1184: END IF;
1185:
1186: hr_utility.trace('l_rate : '||l_rate);
1187: hr_utility.trace('l_balance : '||l_balance);
1188: hr_utility.trace('l_previous_balance : '||l_previous_balance);
1189:
1190: IF p_dimension = 'QTD' THEN
1191: l_calculated := l_calculated + (l_balance - l_previous_balance) * l_rate;
1192: ELSE

Line 1198: hr_utility.trace('l_calculated'||l_calculated);

1194: END IF;
1195:
1196: l_previous_balance := l_balance;
1197:
1198: hr_utility.trace('l_calculated'||l_calculated);
1199:
1200: FETCH c_get_federal_rates INTO l_effective_start_date,l_effective_end_date,
1201: l_futa_rate,l_ss_ee_rate,l_ss_er_rate,
1202: l_medi_ee_rate,l_medi_er_rate;

Line 1209: hr_utility.trace('l_calculated : '||l_calculated );

1205: END LOOP;
1206:
1207: CLOSE c_get_federal_rates;
1208:
1209: hr_utility.trace('l_calculated : '||l_calculated );
1210: RETURN l_calculated;
1211:
1212: EXCEPTION
1213:

Line 1216: hr_utility.trace('Entered into Exception in get_calculated_fed_limit_tax function');

1212: EXCEPTION
1213:
1214: WHEN OTHERS THEN
1215:
1216: hr_utility.trace('Entered into Exception in get_calculated_fed_limit_tax function');
1217:
1218: END get_calculated_fed_limit_tax;
1219:
1220: /*************************************************************************

Line 1402: hr_utility.trace('L_count ' || to_char(l_count));

1398: OPEN c_get_state_code(IN_sui_state_code);
1399: FETCH c_get_state_code into l_sui_state_code;
1400: CLOSE c_get_state_code;
1401:
1402: hr_utility.trace('L_count ' || to_char(l_count));
1403: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
1404: IF l_count > 0 THEN
1405: For i in 1..l_count
1406: LOOP

Line 1403: hr_utility.trace('Org Id ' || to_char(IN_organization_id));

1399: FETCH c_get_state_code into l_sui_state_code;
1400: CLOSE c_get_state_code;
1401:
1402: hr_utility.trace('L_count ' || to_char(l_count));
1403: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
1404: IF l_count > 0 THEN
1405: For i in 1..l_count
1406: LOOP
1407: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);

Line 1407: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);

1403: hr_utility.trace('Org Id ' || to_char(IN_organization_id));
1404: IF l_count > 0 THEN
1405: For i in 1..l_count
1406: LOOP
1407: hr_utility.trace('IN_sui_state_code : ' || IN_sui_state_code);
1408: IF payusunb_pkg.futa_credit_info.exists(i) THEN
1409: IF payusunb_pkg.futa_credit_info(i).organization_id = IN_organization_id THEN
1410: l_flag := 'T' ;
1411: IF (payusunb_pkg.futa_credit_info(i).sui_state_code = l_sui_state_code) THEN

Line 1425: hr_utility.trace('State_code pupulated : ' || l_futa_state_code);

1421: LOOP
1422: l_count := l_count + 1;
1423: FETCH c_get_futa_credit_rt INTO l_futa_state_code,l_futa_credit_rate ;
1424: EXIT WHEN c_get_futa_credit_rt%NOTFOUND;
1425: hr_utility.trace('State_code pupulated : ' || l_futa_state_code);
1426: payusunb_pkg.futa_credit_info(l_count).organization_id := IN_organization_id;
1427: payusunb_pkg.futa_credit_info(l_count).sui_state_code := l_futa_state_code;
1428: payusunb_pkg.futa_credit_info(l_count).futa_credit_rate := NVL(l_futa_credit_rate,-1);
1429: IF l_futa_state_code = l_sui_state_code THEN

Line 1436: hr_utility.trace('return value : ' || L_return_val);

1432:
1433: END LOOP;
1434: CLOSE c_get_futa_credit_rt;
1435: END IF;
1436: hr_utility.trace('return value : ' || L_return_val);
1437:
1438: RETURN nvl(L_return_val,-1);
1439:
1440: END fnc_get_futa_credit_rate;

Line 1469: hr_utility.trace('Inside the sui_override');

1465: ln_count NUMBER;
1466:
1467: BEGIN
1468: IF payusunb_pkg.sui_sdi_override_info.count < 1 THEN
1469: hr_utility.trace('Inside the sui_override');
1470: OPEN c_get_sui_sdi_overide_rt ( IN_tax_unit_id );
1471: LOOP
1472: FETCH c_get_sui_sdi_overide_rt INTO lv_state_code,ln_sui_override_rt,ln_sui_dummy_rt,ln_sdi_override_rt ;
1473: EXIT WHEN c_get_sui_sdi_overide_rt%NOTFOUND;

Line 2426: hr_utility.trace('FIT - prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);

2422: -- added new pre-tax balance - tmehra
2423: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
2424: L_as_of_date,L_dimension, 'FIT', 'PRE_TAX_REDNS', 'EE',
2425: NULL, L_fit_ee_pretax_redns);
2426: hr_utility.trace('FIT - prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);
2427: END IF;
2428:
2429: -- if tax_type is anything but Medicare, SS, FUTA,
2430: -- then get subj whable balance for later use

Line 2436: hr_utility.trace('NOT FUTA- prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);

2432: OR L_tax_type IS NULL THEN
2433: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
2434: L_as_of_date, L_dimension, 'FIT', 'SUBJ_WHABLE', 'EE',
2435: NULL, L_fit_ee_subj_whable);
2436: hr_utility.trace('NOT FUTA- prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);
2437: END IF;
2438:
2439: IF L_tax_type = 'FIT' OR L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
2440: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);

Line 2440: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);

2436: hr_utility.trace('NOT FUTA- prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);
2437: END IF;
2438:
2439: IF L_tax_type = 'FIT' OR L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
2440: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);
2441: hr_utility.trace('prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);
2442: L_fit_ee_reduced_s_whable := L_fit_ee_subj_whable - L_fit_ee_pretax_redns;
2443: hr_utility.trace('prc_federal_balances - L_fit_ee_reduced_s_whable: ' || L_fit_ee_reduced_s_whable);
2444: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,

Line 2441: hr_utility.trace('prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);

2437: END IF;
2438:
2439: IF L_tax_type = 'FIT' OR L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
2440: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);
2441: hr_utility.trace('prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);
2442: L_fit_ee_reduced_s_whable := L_fit_ee_subj_whable - L_fit_ee_pretax_redns;
2443: hr_utility.trace('prc_federal_balances - L_fit_ee_reduced_s_whable: ' || L_fit_ee_reduced_s_whable);
2444: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
2445: L_as_of_date, L_dimension, 'FIT', 'SUBJ_NWHABLE', 'EE',

Line 2443: hr_utility.trace('prc_federal_balances - L_fit_ee_reduced_s_whable: ' || L_fit_ee_reduced_s_whable);

2439: IF L_tax_type = 'FIT' OR L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
2440: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_whable: ' || L_fit_ee_subj_whable);
2441: hr_utility.trace('prc_federal_balances - L_fit_ee_pretax_redns: ' || L_fit_ee_pretax_redns);
2442: L_fit_ee_reduced_s_whable := L_fit_ee_subj_whable - L_fit_ee_pretax_redns;
2443: hr_utility.trace('prc_federal_balances - L_fit_ee_reduced_s_whable: ' || L_fit_ee_reduced_s_whable);
2444: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
2445: L_as_of_date, L_dimension, 'FIT', 'SUBJ_NWHABLE', 'EE',
2446: NULL, L_fit_ee_subj_nwhable);
2447: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_nwhable: ' || L_fit_ee_subj_nwhable);

Line 2447: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_nwhable: ' || L_fit_ee_subj_nwhable);

2443: hr_utility.trace('prc_federal_balances - L_fit_ee_reduced_s_whable: ' || L_fit_ee_reduced_s_whable);
2444: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
2445: L_as_of_date, L_dimension, 'FIT', 'SUBJ_NWHABLE', 'EE',
2446: NULL, L_fit_ee_subj_nwhable);
2447: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_nwhable: ' || L_fit_ee_subj_nwhable);
2448: L_fit_ee_subject := L_fit_ee_subj_whable + L_fit_ee_subj_nwhable;
2449: hr_utility.trace('prc_federal_balances - L_fit_ee_subject: ' || L_fit_ee_subject);
2450: END IF;
2451:

Line 2449: hr_utility.trace('prc_federal_balances - L_fit_ee_subject: ' || L_fit_ee_subject);

2445: L_as_of_date, L_dimension, 'FIT', 'SUBJ_NWHABLE', 'EE',
2446: NULL, L_fit_ee_subj_nwhable);
2447: hr_utility.trace('prc_federal_balances - L_fit_ee_subj_nwhable: ' || L_fit_ee_subj_nwhable);
2448: L_fit_ee_subject := L_fit_ee_subj_whable + L_fit_ee_subj_nwhable;
2449: hr_utility.trace('prc_federal_balances - L_fit_ee_subject: ' || L_fit_ee_subject);
2450: END IF;
2451:
2452: IF L_tax_type = 'FIT' OR L_tax_type IS NULL THEN
2453:

Line 3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);

3133: /*End of Changes for Bug#13394260*/
3134:
3135: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3136: BEGIN
3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);
3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);
3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);
3140: hr_utility.trace('prc_state_balances - L_tax_type: ' || L_tax_type);
3141: IF L_tax_type = 'SIT' OR L_tax_type IS NULL THEN

Line 3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);

3134:
3135: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3136: BEGIN
3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);
3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);
3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);
3140: hr_utility.trace('prc_state_balances - L_tax_type: ' || L_tax_type);
3141: IF L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
3142: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,

Line 3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);

3135: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3136: BEGIN
3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);
3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);
3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);
3140: hr_utility.trace('prc_state_balances - L_tax_type: ' || L_tax_type);
3141: IF L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
3142: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3143: L_as_of_date, L_dimension, 'SIT', 'WITHHELD', 'EE',

Line 3140: hr_utility.trace('prc_state_balances - L_tax_type: ' || L_tax_type);

3136: BEGIN
3137: hr_utility.trace('prc_state_balances - curr_jurisdiction_code: ' || curr_jurisdiction_code);
3138: hr_utility.trace('prc_state_balances - curr_state_code: ' || curr_state_code);
3139: hr_utility.trace('prc_state_balances - curr_state_abbrev: ' || curr_state_abbrev);
3140: hr_utility.trace('prc_state_balances - L_tax_type: ' || L_tax_type);
3141: IF L_tax_type = 'SIT' OR L_tax_type IS NULL THEN
3142: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3143: L_as_of_date, L_dimension, 'SIT', 'WITHHELD', 'EE',
3144: curr_jurisdiction_code,

Line 3146: hr_utility.trace('prc_state_balances - L_sit_ee_withheld: ' || L_sit_ee_withheld);

3142: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3143: L_as_of_date, L_dimension, 'SIT', 'WITHHELD', 'EE',
3144: curr_jurisdiction_code,
3145: L_sit_ee_withheld);
3146: hr_utility.trace('prc_state_balances - L_sit_ee_withheld: ' || L_sit_ee_withheld);
3147: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3148: L_as_of_date, L_dimension, 'SIT', 'SUBJ_WHABLE', 'EE',
3149: curr_jurisdiction_code,
3150: L_sit_ee_subj_whable);

Line 3151: hr_utility.trace('prc_state_balances - L_sit_ee_subj_whable: ' || L_sit_ee_subj_whable);

3147: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3148: L_as_of_date, L_dimension, 'SIT', 'SUBJ_WHABLE', 'EE',
3149: curr_jurisdiction_code,
3150: L_sit_ee_subj_whable);
3151: hr_utility.trace('prc_state_balances - L_sit_ee_subj_whable: ' || L_sit_ee_subj_whable);
3152: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3153: L_as_of_date, L_dimension, 'SIT', 'SUBJ_NWHABLE', 'EE',
3154: curr_jurisdiction_code,
3155: L_sit_ee_subj_nwhable);

Line 3156: hr_utility.trace('prc_state_balances - L_sit_ee_subj_nwhable: ' || L_sit_ee_subj_nwhable);

3152: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3153: L_as_of_date, L_dimension, 'SIT', 'SUBJ_NWHABLE', 'EE',
3154: curr_jurisdiction_code,
3155: L_sit_ee_subj_nwhable);
3156: hr_utility.trace('prc_state_balances - L_sit_ee_subj_nwhable: ' || L_sit_ee_subj_nwhable);
3157: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3158: L_as_of_date,L_dimension, 'SIT', 'PRE_TAX_REDNS', 'EE',
3159: curr_jurisdiction_code,
3160: L_sit_ee_pretax_redns);

Line 3161: hr_utility.trace('prc_state_balances - L_sit_ee_pretax_redns: ' || L_sit_ee_pretax_redns);

3157: prc_get_balance(L_asg_action_id, IN_prc_tax_unit_id,
3158: L_as_of_date,L_dimension, 'SIT', 'PRE_TAX_REDNS', 'EE',
3159: curr_jurisdiction_code,
3160: L_sit_ee_pretax_redns);
3161: hr_utility.trace('prc_state_balances - L_sit_ee_pretax_redns: ' || L_sit_ee_pretax_redns);
3162: L_sit_ee_subject := L_sit_ee_subj_whable + L_sit_ee_subj_nwhable;
3163: L_sit_ee_reduced_s_whable := L_sit_ee_subj_whable - L_sit_ee_pretax_redns;
3164: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3165: hr_utility.trace('prc_state_balances - L_sit_ee_reduced_s_whable: ' || L_sit_ee_reduced_s_whable);

Line 3164: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);

3160: L_sit_ee_pretax_redns);
3161: hr_utility.trace('prc_state_balances - L_sit_ee_pretax_redns: ' || L_sit_ee_pretax_redns);
3162: L_sit_ee_subject := L_sit_ee_subj_whable + L_sit_ee_subj_nwhable;
3163: L_sit_ee_reduced_s_whable := L_sit_ee_subj_whable - L_sit_ee_pretax_redns;
3164: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3165: hr_utility.trace('prc_state_balances - L_sit_ee_reduced_s_whable: ' || L_sit_ee_reduced_s_whable);
3166: -- j)
3167: IF L_sit_ee_subj_whable <= 0 AND L_sit_ee_withheld > 0 THEN
3168:

Line 3165: hr_utility.trace('prc_state_balances - L_sit_ee_reduced_s_whable: ' || L_sit_ee_reduced_s_whable);

3161: hr_utility.trace('prc_state_balances - L_sit_ee_pretax_redns: ' || L_sit_ee_pretax_redns);
3162: L_sit_ee_subject := L_sit_ee_subj_whable + L_sit_ee_subj_nwhable;
3163: L_sit_ee_reduced_s_whable := L_sit_ee_subj_whable - L_sit_ee_pretax_redns;
3164: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3165: hr_utility.trace('prc_state_balances - L_sit_ee_reduced_s_whable: ' || L_sit_ee_reduced_s_whable);
3166: -- j)
3167: IF L_sit_ee_subj_whable <= 0 AND L_sit_ee_withheld > 0 THEN
3168:
3169: L_balance_nm1 := L_dimension || ' SIT Subject Withholdable';

Line 3215: hr_utility.trace('prc_state_balances - L_fit_ee_subject: ' || L_fit_ee_subject);

3211: L_asg_action_id,
3212: IN_prc_assignment_id );
3213: END IF;
3214:
3215: hr_utility.trace('prc_state_balances - L_fit_ee_subject: ' || L_fit_ee_subject);
3216: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3217: -- o)
3218: IF L_fit_ee_subject < L_sit_ee_subject THEN
3219: hr_utility.trace('prc_state_balances - If condition FIT < SIT');

Line 3216: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);

3212: IN_prc_assignment_id );
3213: END IF;
3214:
3215: hr_utility.trace('prc_state_balances - L_fit_ee_subject: ' || L_fit_ee_subject);
3216: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3217: -- o)
3218: IF L_fit_ee_subject < L_sit_ee_subject THEN
3219: hr_utility.trace('prc_state_balances - If condition FIT < SIT');
3220: L_balance_nm1 := L_dimension || ' FIT Subject';

Line 3219: hr_utility.trace('prc_state_balances - If condition FIT < SIT');

3215: hr_utility.trace('prc_state_balances - L_fit_ee_subject: ' || L_fit_ee_subject);
3216: hr_utility.trace('prc_state_balances - L_sit_ee_subject: ' || L_sit_ee_subject);
3217: -- o)
3218: IF L_fit_ee_subject < L_sit_ee_subject THEN
3219: hr_utility.trace('prc_state_balances - If condition FIT < SIT');
3220: L_balance_nm1 := L_dimension || ' FIT Subject';
3221: L_balance_nm2 := L_dimension || ' SIT Subject';
3222: L_main_mesg := '*** ' || L_dimension || ' FIT Subject < ' || L_dimension || ' SIT Subject ***';
3223:

Line 4359: hr_utility.trace('L_dimension: ' || L_dimension);

4355: L_tax_type_state := fnc_get_parameter('T_T_S',L_leg_param);
4356: L_usr_SDI_ER_rate := fnc_get_parameter('ERR',L_leg_param);
4357: L_usr_SDI_EE_rate := fnc_get_parameter('EER',L_leg_param);
4358:
4359: hr_utility.trace('L_dimension: ' || L_dimension);
4360: hr_utility.trace('L_tax_type: ' || L_tax_type);
4361: hr_utility.trace('L_tax_type_state: ' || L_tax_type_state);
4362:
4363: -- calculate first half date for later use if type is SUI

Line 4360: hr_utility.trace('L_tax_type: ' || L_tax_type);

4356: L_usr_SDI_ER_rate := fnc_get_parameter('ERR',L_leg_param);
4357: L_usr_SDI_EE_rate := fnc_get_parameter('EER',L_leg_param);
4358:
4359: hr_utility.trace('L_dimension: ' || L_dimension);
4360: hr_utility.trace('L_tax_type: ' || L_tax_type);
4361: hr_utility.trace('L_tax_type_state: ' || L_tax_type_state);
4362:
4363: -- calculate first half date for later use if type is SUI
4364: --L_first_half_date := TO_DATE('30-JUN-'||TO_CHAR(L_as_of_date,'YYYY'),'DD-MON-YYYY');

Line 4361: hr_utility.trace('L_tax_type_state: ' || L_tax_type_state);

4357: L_usr_SDI_EE_rate := fnc_get_parameter('EER',L_leg_param);
4358:
4359: hr_utility.trace('L_dimension: ' || L_dimension);
4360: hr_utility.trace('L_tax_type: ' || L_tax_type);
4361: hr_utility.trace('L_tax_type_state: ' || L_tax_type_state);
4362:
4363: -- calculate first half date for later use if type is SUI
4364: --L_first_half_date := TO_DATE('30-JUN-'||TO_CHAR(L_as_of_date,'YYYY'),'DD-MON-YYYY');
4365: L_first_half_date := TO_DATE('30-06-'||TO_CHAR(L_as_of_date,'YYYY'),'DD-MM-YYYY');

Line 4367: hr_utility.trace('L_first_half_date: ' || to_char(L_first_half_date,'DD-MON-YYYY'));

4363: -- calculate first half date for later use if type is SUI
4364: --L_first_half_date := TO_DATE('30-JUN-'||TO_CHAR(L_as_of_date,'YYYY'),'DD-MON-YYYY');
4365: L_first_half_date := TO_DATE('30-06-'||TO_CHAR(L_as_of_date,'YYYY'),'DD-MM-YYYY');
4366:
4367: hr_utility.trace('L_first_half_date: ' || to_char(L_first_half_date,'DD-MON-YYYY'));
4368: -- calculate the start date based on YTD or QTD dimensions
4369:
4370: /***********************3005756 START *********************************/
4371:

Line 4450: hr_utility.trace('after code changes G_state_flag: ' || G_state_flag);

4446: L_sum_sui_er_bal := 0;
4447: L_sum_sdi_ee_bal := 0;
4448:
4449: /************************ 3005756 start *******************************************************/
4450: hr_utility.trace('after code changes G_state_flag: ' || G_state_flag);
4451: IF G_state_flag = 'Y' THEN
4452:
4453: hr_utility.trace('Balances are valid .Inside vailid state cursor');
4454:

Line 4453: hr_utility.trace('Balances are valid .Inside vailid state cursor');

4449: /************************ 3005756 start *******************************************************/
4450: hr_utility.trace('after code changes G_state_flag: ' || G_state_flag);
4451: IF G_state_flag = 'Y' THEN
4452:
4453: hr_utility.trace('Balances are valid .Inside vailid state cursor');
4454:
4455:
4456: FOR curr_state IN c_state_jurisdictions_valid(IN_prc_person_id,
4457: L_tax_type_state, L_start_date,

Line 4461: hr_utility.trace('Valid - State Code: ' || curr_state.state_code);

4457: L_tax_type_state, L_start_date,
4458: L_as_of_date)
4459: LOOP
4460:
4461: hr_utility.trace('Valid - State Code: ' || curr_state.state_code);
4462: hr_utility.trace('Valid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4463: hr_utility.trace('Valid - state_abbrev: ' || curr_state.state_abbrev);
4464: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);
4465:

Line 4462: hr_utility.trace('Valid - jurisdiction_code: ' || curr_state.jurisdiction_code);

4458: L_as_of_date)
4459: LOOP
4460:
4461: hr_utility.trace('Valid - State Code: ' || curr_state.state_code);
4462: hr_utility.trace('Valid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4463: hr_utility.trace('Valid - state_abbrev: ' || curr_state.state_abbrev);
4464: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);
4465:
4466: END LOOP; -- end curr_state

Line 4463: hr_utility.trace('Valid - state_abbrev: ' || curr_state.state_abbrev);

4459: LOOP
4460:
4461: hr_utility.trace('Valid - State Code: ' || curr_state.state_code);
4462: hr_utility.trace('Valid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4463: hr_utility.trace('Valid - state_abbrev: ' || curr_state.state_abbrev);
4464: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);
4465:
4466: END LOOP; -- end curr_state
4467:

Line 4469: hr_utility.trace('Balances are invalid .Inside invalid state cursor');

4465:
4466: END LOOP; -- end curr_state
4467:
4468: ELSE
4469: hr_utility.trace('Balances are invalid .Inside invalid state cursor');
4470:
4471:
4472: FOR curr_state IN c_state_jurisdictions(IN_prc_person_id,
4473: L_tax_type_state, L_start_date,

Line 4476: hr_utility.trace('Invalid - State Code: ' || curr_state.state_code);

4472: FOR curr_state IN c_state_jurisdictions(IN_prc_person_id,
4473: L_tax_type_state, L_start_date,
4474: l_cursor_fetch_date)
4475: LOOP
4476: hr_utility.trace('Invalid - State Code: ' || curr_state.state_code);
4477: hr_utility.trace('Invalid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4478: hr_utility.trace('Invalid - state_abbrev: ' || curr_state.state_abbrev);
4479:
4480: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);

Line 4477: hr_utility.trace('Invalid - jurisdiction_code: ' || curr_state.jurisdiction_code);

4473: L_tax_type_state, L_start_date,
4474: l_cursor_fetch_date)
4475: LOOP
4476: hr_utility.trace('Invalid - State Code: ' || curr_state.state_code);
4477: hr_utility.trace('Invalid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4478: hr_utility.trace('Invalid - state_abbrev: ' || curr_state.state_abbrev);
4479:
4480: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);
4481:

Line 4478: hr_utility.trace('Invalid - state_abbrev: ' || curr_state.state_abbrev);

4474: l_cursor_fetch_date)
4475: LOOP
4476: hr_utility.trace('Invalid - State Code: ' || curr_state.state_code);
4477: hr_utility.trace('Invalid - jurisdiction_code: ' || curr_state.jurisdiction_code);
4478: hr_utility.trace('Invalid - state_abbrev: ' || curr_state.state_abbrev);
4479:
4480: prc_state_balances ( curr_state.jurisdiction_code,curr_state.state_code,curr_state.state_abbrev);
4481:
4482: END LOOP; -- end curr_state

Line 4500: hr_utility.trace('Balances are valid .Inside valid county cursor');

4496:
4497: /******************** 3005756 start ***********************************************/
4498:
4499: IF G_county_flag = 'Y' THEN
4500: hr_utility.trace('Balances are valid .Inside valid county cursor');
4501:
4502: FOR curr_county IN c_county_jurisdictions_valid(IN_prc_person_id,
4503: L_tax_type_state, L_start_date,
4504: L_as_of_date)

Line 4512: hr_utility.trace('Balances are invalid .Inside invalid county cursor');

4508:
4509: END LOOP; -- end curr_county loop
4510:
4511: ELSE
4512: hr_utility.trace('Balances are invalid .Inside invalid county cursor');
4513:
4514:
4515: FOR curr_county IN c_county_jurisdictions(IN_prc_person_id,
4516: L_tax_type_state, L_start_date,

Line 4534: hr_utility.trace('Balances are valid .Inside valid city cursor');

4530:
4531: /*********************** 3005756 start *****************************************/
4532:
4533: IF G_city_flag = 'Y' THEN
4534: hr_utility.trace('Balances are valid .Inside valid city cursor');
4535:
4536: FOR curr_city IN c_city_jurisdictions_valid(IN_prc_person_id,
4537: L_tax_type_state, L_start_date,
4538: L_as_of_date)

Line 4546: hr_utility.trace('Balances are invalid .Inside invalid city cursor');

4542:
4543: END LOOP; -- end curr_city loop
4544:
4545: ELSE
4546: hr_utility.trace('Balances are invalid .Inside invalid city cursor');
4547:
4548:
4549: FOR curr_city IN c_city_jurisdictions(IN_prc_person_id,
4550: L_tax_type_state, L_start_date,

Line 4568: hr_utility.trace('Balances are valid .Inside valid school cursor');

4564:
4565: /**************************** 3005756 start **********************************/
4566:
4567: IF G_school_flag = 'Y' THEN
4568: hr_utility.trace('Balances are valid .Inside valid school cursor');
4569:
4570: FOR curr_school IN c_school_jurisdictions_valid(IN_prc_person_id,
4571: L_tax_type_state,
4572: IN_prc_tax_unit_id, L_start_date,

Line 4583: hr_utility.trace('Balances are invalid .Inside invalid school cursor');

4579:
4580: END LOOP; -- end curr_school loop
4581:
4582: ELSE
4583: hr_utility.trace('Balances are invalid .Inside invalid school cursor');
4584:
4585:
4586: FOR curr_school IN c_school_jurisdictions(IN_prc_person_id,
4587: L_tax_type_state,