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.PSP_PAYTRN dependencies on DUAL

Line 814: FROM dual;

810: close get_payroll_assig_actions_csr; */
811:
812: SELECT psp_st_run_id_s.nextval
813: INTO l_run_id
814: FROM dual;
815:
816: open get_payroll_assig_actions_csr;
817:
818: fetch get_payroll_assig_actions_csr into g_payroll_asg_rec;

Line 1277: FROM DUAL;

1273: IF (l_export_id IS NULL) THEN
1274: -- End of bug fix 2916848
1275:
1276: SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
1277: FROM DUAL;
1278:
1279: l_total_num_rec:= l_total_num_rec + 1;
1280: l_cur_rec:= l_total_num_rec;
1281:

Line 1377: FROM DUAL;

1373: END IF;
1374: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1375:
1376: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
1377: FROM DUAL;
1378: x_rowid := NULL;
1379:
1380: -- intro this IF-ENDIF and changed the next IF stmt to check gms_posting_date for 2426343
1381: If g_non_active_flag = 'Y' then

Line 2072: FROM DUAL

2068:
2069: PROCEDURE create_working_calendar (p_assignment_id IN NUMBER) IS
2070: CURSOR business_days_cur IS
2071: SELECT DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')
2072: FROM DUAL
2073: CONNECT BY 1=1
2074: AND ROWNUM <= (g_end_date + 1) - g_start_date;
2075: BEGIN
2076: OPEN business_days_cur;

Line 3047: FROM DUAL;

3043: else
3044: l_total_daily_rate := l_daily_rate + l_daily_balance;
3045: end if;
3046: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3047: FROM DUAL;
3048: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3049: hr_utility.trace(' inserting into Sublines -1');
3050: if l_total_daily_Rate > 0 then
3051:

Line 3120: FROM DUAL;

3116: else
3117: l_balance_salary := 0.00;
3118: end if;
3119: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3120: FROM DUAL;
3121: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3122: hr_utility.trace(' inserting into Sublines -2');
3123: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3124: X_ROWID => l_rowid,

Line 3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line 3279: FROM DUAL;

3275: ----dbms_output.PUT_LINE('Daily rate ' || to_char(l_daily_rate+l_daily_balance));
3276: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3277:
3278: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3279: FROM DUAL;
3280: hr_utility.trace(' inserting into Sublines -5');
3281: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3282: X_ROWID => l_rowid,
3283: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3527: FROM DUAL;

3523: end if;
3524: -- ----dbms_output.put_line('Entered 3rd if ..');
3525:
3526: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3527: FROM DUAL;
3528: hr_utility.trace(' inserting into Sublines -6');
3529: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3530: X_ROWID => l_rowid,
3531: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3576: FROM DUAL;

3572:
3573: l_tmp_start_date := trunc(l_start_date);
3574: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3575: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3576: FROM DUAL;
3577: hr_utility.trace(' inserting into Sublines -7');
3578: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3579: X_ROWID => l_rowid,
3580: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3632: FROM DUAL;

3628:
3629: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3630: l_tmp_end_date := trunc(l_end_date);
3631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3632: FROM DUAL;
3633: hr_utility.trace(' inserting into Sublines -8');
3634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3635: X_ROWID => l_rowid,
3636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3696: FROM DUAL;

3692: if round(x_balance_amount,g_precision) <> 0.00 then
3693: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3694: end if;
3695: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3696: FROM DUAL;
3697: hr_utility.trace(' inserting into Sublines -10');
3698: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3699: X_ROWID => l_rowid,
3700: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3766: FROM DUAL;

3762: if round(x_balance_amount,g_precision) <> 0.00 then
3763: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3764: end if;
3765: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3766: FROM DUAL;
3767: hr_utility.trace(' inserting into Sublines -12');
3768: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3769: X_ROWID => l_rowid,
3770: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3814: FROM DUAL;

3810: ----dbms_output.put_line('After 1st Insert ..');
3811: l_tmp_start_date := trunc(l_start_date);
3812: l_tmp_end_date := trunc(l_end_date) ;
3813: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3814: FROM DUAL;
3815: hr_utility.trace(' inserting into Sublines -13');
3816: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3817: X_ROWID => l_rowid,
3818: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3878: FROM DUAL;

3874: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3875:
3876: end if;
3877: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3878: FROM DUAL;
3879: hr_utility.trace(' inserting into Sublines -14');
3880: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3881: X_ROWID => l_rowid,
3882: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3950: FROM DUAL;

3946: if round(x_balance_amount,g_precision) <> 0.00 then
3947: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3948: end if;
3949: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3950: FROM DUAL;
3951: hr_utility.trace(' inserting into Sublines -15');
3952: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3953: X_ROWID => l_rowid,
3954: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3999: FROM DUAL;

3995: l_tmp_start_date := trunc(g_sublines_rec.sub_line_end_date);
3996: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3997:
3998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3999: FROM DUAL;
4000: hr_utility.trace(' inserting into Sublines -17');
4001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4002: X_ROWID => l_rowid,
4003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4054: FROM DUAL;

4050: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
4051: l_tmp_end_date := trunc(l_end_date);
4052:
4053: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4054: FROM DUAL;
4055: hr_utility.trace(' inserting into Sublines -19');
4056: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4057: X_ROWID => l_rowid,
4058: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4117: FROM DUAL;

4113: if round(x_balance_amount,g_precision) <> 0.00 then
4114: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4115: end if;
4116: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4117: FROM DUAL;
4118: hr_utility.trace(' inserting into Sublines -21');
4119: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4120: X_ROWID => l_rowid,
4121: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4244: FROM DUAL;

4240: EXIT WHEN get_sublines_csr%NOTFOUND;
4241: if l_date_start > g_sublines_rec.sub_line_start_date then
4242: l_tmp_end_date := trunc(l_date_start) - 1;
4243: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4244: FROM DUAL;
4245: hr_utility.trace(' inserting into Sublines -22');
4246: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4247: X_ROWID => l_rowid,
4248: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4291: FROM DUAL;

4287: X_MODE => 'R');
4288:
4289: l_tmp_start_date := trunc(l_date_start);
4290: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4291: FROM DUAL;
4292: hr_utility.trace(' inserting into Sublines -25');
4293: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4294: X_ROWID => l_rowid,
4295: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4357: FROM DUAL;

4353: EXIT WHEN get_sublines_csr%NOTFOUND;
4354: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4355: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4356: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4357: FROM DUAL;
4358: hr_utility.trace(' inserting into Sublines -28');
4359: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4360: X_ROWID => l_rowid,
4361: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4404: FROM DUAL;

4400: X_MODE => 'R');
4401:
4402: l_tmp_start_date := trunc(l_actual_termination_date);
4403: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4404: FROM DUAL;
4405: hr_utility.trace(' inserting into Sublines -30');
4406: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4407: X_ROWID => l_rowid,
4408: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4590: FROM DUAL;

4586: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4587: end if;
4588:
4589: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4590: FROM DUAL;
4591: hr_utility.trace(' inserting into Sublines -32');
4592: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4593: X_ROWID => l_rowid,
4594: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4654: FROM DUAL;

4650: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4651: end if;
4652:
4653: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4654: FROM DUAL;
4655: hr_utility.trace(' inserting into Sublines -33');
4656: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4657: X_ROWID => l_rowid,
4658: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4727: FROM DUAL;

4723: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4724: end if;
4725:
4726: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4727: FROM DUAL;
4728: hr_utility.trace(' inserting into Sublines -34');
4729: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4730: X_ROWID => l_rowid,
4731: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4791: FROM DUAL;

4787: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4788: end if;
4789:
4790: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4791: FROM DUAL;
4792: hr_utility.trace(' inserting into Sublines -35');
4793: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4794: X_ROWID => l_rowid,
4795: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4861: FROM DUAL;

4857: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4858: end if;
4859:
4860: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4861: FROM DUAL;
4862: hr_utility.trace(' inserting into Sublines -37');
4863: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4864: X_ROWID => l_rowid,
4865: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4925: FROM DUAL;

4921: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4922: end if;
4923:
4924: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4925: FROM DUAL;
4926: hr_utility.trace(' inserting into Sublines -39');
4927: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4928: X_ROWID => l_rowid,
4929: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4989: FROM DUAL;

4985: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4986: end if;
4987:
4988: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4989: FROM DUAL;
4990: hr_utility.trace(' inserting into Sublines -42');
4991: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4992: X_ROWID => l_rowid,
4993: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5175: FROM DUAL;

5171: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5172: end if;
5173:
5174: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5175: FROM DUAL;
5176: hr_utility.trace(' inserting into Sublines -52');
5177: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5178: X_ROWID => l_rowid,
5179: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5239: FROM DUAL;

5235: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5236: end if;
5237:
5238: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5239: FROM DUAL;
5240: hr_utility.trace(' inserting into Sublines -62');
5241: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5242: X_ROWID => l_rowid,
5243: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5312: FROM DUAL;

5308: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5309: end if;
5310:
5311: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5312: FROM DUAL;
5313: hr_utility.trace(' inserting into Sublines -92');
5314: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5315: X_ROWID => l_rowid,
5316: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5376: FROM DUAL;

5372: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5373: end if;
5374:
5375: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5376: FROM DUAL;
5377: hr_utility.trace(' inserting into Sublines -102');
5378: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5379: X_ROWID => l_rowid,
5380: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5446: FROM DUAL;

5442: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5443: end if;
5444:
5445: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5446: FROM DUAL;
5447: hr_utility.trace(' inserting into Sublines -202');
5448: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5449: X_ROWID => l_rowid,
5450: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5510: FROM DUAL;

5506: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5507: end if;
5508:
5509: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5510: FROM DUAL;
5511: hr_utility.trace(' inserting into Sublines -302');
5512: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5513: X_ROWID => l_rowid,
5514: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5574: FROM DUAL;

5570: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5571: end if;
5572:
5573: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5574: FROM DUAL;
5575: hr_utility.trace(' inserting into Sublines -402');
5576: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5577: X_ROWID => l_rowid,
5578: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5765: FROM DUAL;

5761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5762: end if;
5763:
5764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5765: FROM DUAL;
5766: hr_utility.trace(' inserting into Sublines -502');
5767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5768: X_ROWID => l_rowid,
5769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5829: FROM DUAL;

5825: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5826: end if;
5827:
5828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5829: FROM DUAL;
5830: hr_utility.trace(' inserting into Sublines -502');
5831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5832: X_ROWID => l_rowid,
5833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5902: FROM DUAL;

5898: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5899: end if;
5900:
5901: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5902: FROM DUAL;
5903: hr_utility.trace(' inserting into Sublines -702');
5904: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5905: X_ROWID => l_rowid,
5906: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5966: FROM DUAL;

5962: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5963: end if;
5964:
5965: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5966: FROM DUAL;
5967: hr_utility.trace(' inserting into Sublines -802');
5968: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5969: X_ROWID => l_rowid,
5970: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6036: FROM DUAL;

6032: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6033: end if;
6034:
6035: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6036: FROM DUAL;
6037: hr_utility.trace(' inserting into Sublines -902');
6038: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6039: X_ROWID => l_rowid,
6040: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6100: FROM DUAL;

6096: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)),g_precision);
6097: end if;
6098:
6099: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6100: FROM DUAL;
6101: hr_utility.trace(' inserting into Sublines -802');
6102: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6103: X_ROWID => l_rowid,
6104: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6164: FROM DUAL;

6160: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6161: end if;
6162:
6163: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6164: FROM DUAL;
6165: hr_utility.trace(' inserting into Sublines -1002');
6166: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6167: X_ROWID => l_rowid,
6168: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6356: FROM DUAL;

6352: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6353: end if;
6354:
6355: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6356: FROM DUAL;
6357: hr_utility.trace(' inserting into Sublines -2002');
6358: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6359: X_ROWID => l_rowid,
6360: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6420: FROM DUAL;

6416: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6417: end if;
6418:
6419: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6420: FROM DUAL;
6421: hr_utility.trace(' inserting into Sublines -3002');
6422: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6423: X_ROWID => l_rowid,
6424: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6493: FROM DUAL;

6489: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6490: end if;
6491:
6492: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6493: FROM DUAL;
6494: hr_utility.trace(' inserting into Sublines -4002');
6495: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6496: X_ROWID => l_rowid,
6497: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6557: FROM DUAL;

6553: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6554: end if;
6555:
6556: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6557: FROM DUAL;
6558: hr_utility.trace(' inserting into Sublines -5002');
6559: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6560: X_ROWID => l_rowid,
6561: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6627: FROM DUAL;

6623: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6624: end if;
6625:
6626: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6627: FROM DUAL;
6628: hr_utility.trace(' inserting into Sublines -6002');
6629: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6630: X_ROWID => l_rowid,
6631: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6691: FROM DUAL;

6687: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6688: end if;
6689:
6690: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6691: FROM DUAL;
6692: hr_utility.trace(' inserting into Sublines -7002');
6693: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6694: X_ROWID => l_rowid,
6695: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6755: FROM DUAL;

6751: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6752: end if;
6753:
6754: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6755: FROM DUAL;
6756: hr_utility.trace(' inserting into Sublines -8002');
6757: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6758: X_ROWID => l_rowid,
6759: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6951: FROM DUAL;

6947: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6948: end if;
6949:
6950: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6951: FROM DUAL;
6952: hr_utility.trace(' inserting into Sublines -9002');
6953: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6954: X_ROWID => l_rowid,
6955: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7015: FROM DUAL;

7011: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7012: end if;
7013:
7014: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7015: FROM DUAL;
7016: hr_utility.trace(' inserting into Sublines -2Y');
7017: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7018: X_ROWID => l_rowid,
7019: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7088: FROM DUAL;

7084: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7085: end if;
7086:
7087: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7088: FROM DUAL;
7089: hr_utility.trace(' inserting into Sublines -2OX');
7090: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7091: X_ROWID => l_rowid,
7092: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7152: FROM DUAL;

7148: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7149: end if;
7150:
7151: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7152: FROM DUAL;
7153: hr_utility.trace(' inserting into Sublines -2LXL');
7154: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7155: X_ROWID => l_rowid,
7156: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7222: FROM DUAL;

7218: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7219: end if;
7220:
7221: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7222: FROM DUAL;
7223: hr_utility.trace(' inserting into Sublines -2UIORA');
7224: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7225: X_ROWID => l_rowid,
7226: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7286: FROM DUAL;

7282: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7283: end if;
7284:
7285: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7286: FROM DUAL;
7287: hr_utility.trace(' inserting into Sublines -2JADF');
7288: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7289: X_ROWID => l_rowid,
7290: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7350: FROM DUAL;

7346: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7347: end if;
7348:
7349: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7350: FROM DUAL;
7351: hr_utility.trace(' inserting into Sublines -299ek');
7352: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7353: X_ROWID => l_rowid,
7354: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7630: FROM DUAL;

7626: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7627: end if;
7628:
7629: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7630: FROM DUAL;
7631: hr_utility.trace(' inserting into Sublines -2kdfd');
7632: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7633: X_ROWID => l_rowid,
7634: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7694: FROM DUAL;

7690: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7691: end if;
7692:
7693: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7694: FROM DUAL;
7695: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7696: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7697: X_ROWID => l_rowid,
7698: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7765: FROM DUAL;

7761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7762: end if;
7763:
7764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7765: FROM DUAL;
7766: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7768: X_ROWID => l_rowid,
7769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7829: FROM DUAL;

7825: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7826: end if;
7827:
7828: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7829: FROM DUAL;
7830: hr_utility.trace(' inserting into Sublines -2KKKKK');
7831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7832: X_ROWID => l_rowid,
7833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7899: FROM DUAL;

7895: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7896: end if;
7897:
7898: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7899: FROM DUAL;
7900: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7901: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7902: X_ROWID => l_rowid,
7903: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7963: FROM DUAL;

7959: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7960: end if;
7961:
7962: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7963: FROM DUAL;
7964: hr_utility.trace(' inserting into Sublines -27777MMMN');
7965: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7966: X_ROWID => l_rowid,
7967: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8027: FROM DUAL;

8023: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8024: end if;
8025:
8026: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8027: FROM DUAL;
8028: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8029: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8030: X_ROWID => l_rowid,
8031: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8233: FROM DUAL;

8229: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8230: end if;
8231:
8232: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8233: FROM DUAL;
8234: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8235: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8236: X_ROWID => l_rowid,
8237: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8297: FROM DUAL;

8293: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8294: end if;
8295:
8296: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8297: FROM DUAL;
8298: hr_utility.trace(' inserting into Sublines -29999*****888');
8299: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8300: X_ROWID => l_rowid,
8301: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8370: FROM DUAL;

8366: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8367: end if;
8368:
8369: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8370: FROM DUAL;
8371: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8372: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8373: X_ROWID => l_rowid,
8374: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8434: FROM DUAL;

8430: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8431: end if;
8432:
8433: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8434: FROM DUAL;
8435: hr_utility.trace(' inserting into Sublines -2UKOSO');
8436: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8437: X_ROWID => l_rowid,
8438: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8504: FROM DUAL;

8500: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8501: end if;
8502:
8503: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8504: FROM DUAL;
8505: hr_utility.trace(' inserting into Sublines -2JYUPA');
8506: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8507: X_ROWID => l_rowid,
8508: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8568: FROM DUAL;

8564: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8565: end if;
8566:
8567: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8568: FROM DUAL;
8569: hr_utility.trace(' inserting into Sublines -2NBMM');
8570: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8571: X_ROWID => l_rowid,
8572: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8632: FROM DUAL;

8628: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8629: end if;
8630:
8631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8632: FROM DUAL;
8633: hr_utility.trace(' inserting into Sublines -2TOPP');
8634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8635: X_ROWID => l_rowid,
8636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8867: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

8863: psp_payroll_lines
8864: where payroll_line_id = x_payroll_line_id));
8865:
8866: -- Inserting into PSP_SUB_LINES
8867: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8868: hr_utility.trace(' inserting into Sublines -2UISISI');
8869: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8870: X_ROWID => l_rowid,
8871: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

9046: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9047: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9048: END IF;
9049:
9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9051:
9052: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9053: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9054: (X_ROWID => l_rowid,