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 816: FROM dual;

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

Line 1316: FROM DUAL;

1312: IF (l_export_id IS NULL) THEN
1313: -- End of bug fix 2916848
1314:
1315: SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
1316: FROM DUAL;
1317:
1318: l_total_num_rec:= l_total_num_rec + 1;
1319: l_cur_rec:= l_total_num_rec;
1320:

Line 1416: FROM DUAL;

1412: END IF;
1413: hr_utility.trace(' pass kff ='|| g_pay_costs_rec.cost_allocation_keyflex_id);
1414:
1415: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
1416: FROM DUAL;
1417: x_rowid := NULL;
1418:
1419: -- intro this IF-ENDIF and changed the next IF stmt to check gms_posting_date for 2426343
1420:

Line 2146: FROM DUAL

2142:
2143: PROCEDURE create_working_calendar (p_assignment_id IN NUMBER) IS
2144: CURSOR business_days_cur IS
2145: SELECT DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')
2146: FROM DUAL
2147: CONNECT BY 1=1
2148: AND ROWNUM <= (g_end_date + 1) - g_start_date;
2149: BEGIN
2150: OPEN business_days_cur;

Line 3121: FROM DUAL;

3117: else
3118: l_total_daily_rate := l_daily_rate + l_daily_balance;
3119: end if;
3120: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3121: FROM DUAL;
3122: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3123: hr_utility.trace(' inserting into Sublines -1');
3124: if l_total_daily_Rate > 0 then
3125:

Line 3194: FROM DUAL;

3190: else
3191: l_balance_salary := 0.00;
3192: end if;
3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3194: FROM DUAL;
3195: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3196: hr_utility.trace(' inserting into Sublines -2');
3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3198: X_ROWID => l_rowid,

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

3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line 3353: FROM DUAL;

3349: ----dbms_output.PUT_LINE('Daily rate ' || to_char(l_daily_rate+l_daily_balance));
3350: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3351:
3352: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3353: FROM DUAL;
3354: hr_utility.trace(' inserting into Sublines -5');
3355: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3356: X_ROWID => l_rowid,
3357: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3601: FROM DUAL;

3597: end if;
3598: -- ----dbms_output.put_line('Entered 3rd if ..');
3599:
3600: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3601: FROM DUAL;
3602: hr_utility.trace(' inserting into Sublines -6');
3603: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3604: X_ROWID => l_rowid,
3605: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3650: FROM DUAL;

3646:
3647: l_tmp_start_date := trunc(l_start_date);
3648: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3649: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3650: FROM DUAL;
3651: hr_utility.trace(' inserting into Sublines -7');
3652: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3653: X_ROWID => l_rowid,
3654: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3706: FROM DUAL;

3702:
3703: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3704: l_tmp_end_date := trunc(l_end_date);
3705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3706: FROM DUAL;
3707: hr_utility.trace(' inserting into Sublines -8');
3708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3709: X_ROWID => l_rowid,
3710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3770: FROM DUAL;

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

Line 3840: FROM DUAL;

3836: if round(x_balance_amount,g_precision) <> 0.00 then
3837: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3838: end if;
3839: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3840: FROM DUAL;
3841: hr_utility.trace(' inserting into Sublines -12');
3842: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3843: X_ROWID => l_rowid,
3844: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3888: FROM DUAL;

3884: ----dbms_output.put_line('After 1st Insert ..');
3885: l_tmp_start_date := trunc(l_start_date);
3886: l_tmp_end_date := trunc(l_end_date) ;
3887: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3888: FROM DUAL;
3889: hr_utility.trace(' inserting into Sublines -13');
3890: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3891: X_ROWID => l_rowid,
3892: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 3952: FROM DUAL;

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

Line 4024: FROM DUAL;

4020: if round(x_balance_amount,g_precision) <> 0.00 then
4021: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4022: end if;
4023: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4024: FROM DUAL;
4025: hr_utility.trace(' inserting into Sublines -15');
4026: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4027: X_ROWID => l_rowid,
4028: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4073: FROM DUAL;

4069: l_tmp_start_date := trunc(g_sublines_rec.sub_line_end_date);
4070: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
4071:
4072: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4073: FROM DUAL;
4074: hr_utility.trace(' inserting into Sublines -17');
4075: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4076: X_ROWID => l_rowid,
4077: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4128: FROM DUAL;

4124: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
4125: l_tmp_end_date := trunc(l_end_date);
4126:
4127: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4128: FROM DUAL;
4129: hr_utility.trace(' inserting into Sublines -19');
4130: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4131: X_ROWID => l_rowid,
4132: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4191: FROM DUAL;

4187: if round(x_balance_amount,g_precision) <> 0.00 then
4188: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4189: end if;
4190: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4191: FROM DUAL;
4192: hr_utility.trace(' inserting into Sublines -21');
4193: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4194: X_ROWID => l_rowid,
4195: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4318: FROM DUAL;

4314: EXIT WHEN get_sublines_csr%NOTFOUND;
4315: if l_date_start > g_sublines_rec.sub_line_start_date then
4316: l_tmp_end_date := trunc(l_date_start) - 1;
4317: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4318: FROM DUAL;
4319: hr_utility.trace(' inserting into Sublines -22');
4320: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4321: X_ROWID => l_rowid,
4322: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4365: FROM DUAL;

4361: X_MODE => 'R');
4362:
4363: l_tmp_start_date := trunc(l_date_start);
4364: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4365: FROM DUAL;
4366: hr_utility.trace(' inserting into Sublines -25');
4367: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4368: X_ROWID => l_rowid,
4369: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4431: FROM DUAL;

4427: EXIT WHEN get_sublines_csr%NOTFOUND;
4428: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4429: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4430: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4431: FROM DUAL;
4432: hr_utility.trace(' inserting into Sublines -28');
4433: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4434: X_ROWID => l_rowid,
4435: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4478: FROM DUAL;

4474: X_MODE => 'R');
4475:
4476: l_tmp_start_date := trunc(l_actual_termination_date);
4477: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4478: FROM DUAL;
4479: hr_utility.trace(' inserting into Sublines -30');
4480: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4481: X_ROWID => l_rowid,
4482: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4664: FROM DUAL;

4660: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4661: end if;
4662:
4663: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4664: FROM DUAL;
4665: hr_utility.trace(' inserting into Sublines -32');
4666: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4667: X_ROWID => l_rowid,
4668: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4728: FROM DUAL;

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

Line 4801: FROM DUAL;

4797: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4798: end if;
4799:
4800: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4801: FROM DUAL;
4802: hr_utility.trace(' inserting into Sublines -34');
4803: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4804: X_ROWID => l_rowid,
4805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4865: FROM DUAL;

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

Line 4935: FROM DUAL;

4931: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4932: end if;
4933:
4934: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4935: FROM DUAL;
4936: hr_utility.trace(' inserting into Sublines -37');
4937: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4938: X_ROWID => l_rowid,
4939: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 4999: FROM DUAL;

4995: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4996: end if;
4997:
4998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4999: FROM DUAL;
5000: hr_utility.trace(' inserting into Sublines -39');
5001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5002: X_ROWID => l_rowid,
5003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5063: FROM DUAL;

5059: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5060: end if;
5061:
5062: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5063: FROM DUAL;
5064: hr_utility.trace(' inserting into Sublines -42');
5065: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5066: X_ROWID => l_rowid,
5067: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5249: FROM DUAL;

5245: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5246: end if;
5247:
5248: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5249: FROM DUAL;
5250: hr_utility.trace(' inserting into Sublines -52');
5251: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5252: X_ROWID => l_rowid,
5253: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5313: FROM DUAL;

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

Line 5386: FROM DUAL;

5382: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5383: end if;
5384:
5385: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5386: FROM DUAL;
5387: hr_utility.trace(' inserting into Sublines -92');
5388: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5389: X_ROWID => l_rowid,
5390: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5450: FROM DUAL;

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

Line 5520: FROM DUAL;

5516: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5517: end if;
5518:
5519: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5520: FROM DUAL;
5521: hr_utility.trace(' inserting into Sublines -202');
5522: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5523: X_ROWID => l_rowid,
5524: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5584: FROM DUAL;

5580: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5581: end if;
5582:
5583: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5584: FROM DUAL;
5585: hr_utility.trace(' inserting into Sublines -302');
5586: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5587: X_ROWID => l_rowid,
5588: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5648: FROM DUAL;

5644: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5645: end if;
5646:
5647: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5648: FROM DUAL;
5649: hr_utility.trace(' inserting into Sublines -402');
5650: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5651: X_ROWID => l_rowid,
5652: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5839: FROM DUAL;

5835: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5836: end if;
5837:
5838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5839: FROM DUAL;
5840: hr_utility.trace(' inserting into Sublines -502');
5841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5842: X_ROWID => l_rowid,
5843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 5903: FROM DUAL;

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

Line 5976: FROM DUAL;

5972: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5973: end if;
5974:
5975: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5976: FROM DUAL;
5977: hr_utility.trace(' inserting into Sublines -702');
5978: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5979: X_ROWID => l_rowid,
5980: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6040: FROM DUAL;

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

Line 6110: FROM DUAL;

6106: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6107: end if;
6108:
6109: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6110: FROM DUAL;
6111: hr_utility.trace(' inserting into Sublines -902');
6112: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6113: X_ROWID => l_rowid,
6114: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6174: FROM DUAL;

6170: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)),g_precision);
6171: end if;
6172:
6173: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6174: FROM DUAL;
6175: hr_utility.trace(' inserting into Sublines -802');
6176: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6177: X_ROWID => l_rowid,
6178: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6238: FROM DUAL;

6234: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6235: end if;
6236:
6237: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6238: FROM DUAL;
6239: hr_utility.trace(' inserting into Sublines -1002');
6240: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6241: X_ROWID => l_rowid,
6242: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6430: FROM DUAL;

6426: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6427: end if;
6428:
6429: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6430: FROM DUAL;
6431: hr_utility.trace(' inserting into Sublines -2002');
6432: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6433: X_ROWID => l_rowid,
6434: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6494: FROM DUAL;

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

Line 6567: FROM DUAL;

6563: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6564: end if;
6565:
6566: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6567: FROM DUAL;
6568: hr_utility.trace(' inserting into Sublines -4002');
6569: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6570: X_ROWID => l_rowid,
6571: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6631: FROM DUAL;

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

Line 6701: FROM DUAL;

6697: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6698: end if;
6699:
6700: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6701: FROM DUAL;
6702: hr_utility.trace(' inserting into Sublines -6002');
6703: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6704: X_ROWID => l_rowid,
6705: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6765: FROM DUAL;

6761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6762: end if;
6763:
6764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6765: FROM DUAL;
6766: hr_utility.trace(' inserting into Sublines -7002');
6767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6768: X_ROWID => l_rowid,
6769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 6829: FROM DUAL;

6825: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6826: end if;
6827:
6828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6829: FROM DUAL;
6830: hr_utility.trace(' inserting into Sublines -8002');
6831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6832: X_ROWID => l_rowid,
6833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7025: FROM DUAL;

7021: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7022: end if;
7023:
7024: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7025: FROM DUAL;
7026: hr_utility.trace(' inserting into Sublines -9002');
7027: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7028: X_ROWID => l_rowid,
7029: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7089: FROM DUAL;

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

Line 7162: FROM DUAL;

7158: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7159: end if;
7160:
7161: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7162: FROM DUAL;
7163: hr_utility.trace(' inserting into Sublines -2OX');
7164: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7165: X_ROWID => l_rowid,
7166: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7226: FROM DUAL;

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

Line 7296: FROM DUAL;

7292: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7293: end if;
7294:
7295: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7296: FROM DUAL;
7297: hr_utility.trace(' inserting into Sublines -2UIORA');
7298: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7299: X_ROWID => l_rowid,
7300: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7360: FROM DUAL;

7356: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7357: end if;
7358:
7359: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7360: FROM DUAL;
7361: hr_utility.trace(' inserting into Sublines -2JADF');
7362: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7363: X_ROWID => l_rowid,
7364: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7424: FROM DUAL;

7420: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7421: end if;
7422:
7423: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7424: FROM DUAL;
7425: hr_utility.trace(' inserting into Sublines -299ek');
7426: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7427: X_ROWID => l_rowid,
7428: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7704: FROM DUAL;

7700: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7701: end if;
7702:
7703: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7704: FROM DUAL;
7705: hr_utility.trace(' inserting into Sublines -2kdfd');
7706: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7707: X_ROWID => l_rowid,
7708: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7768: FROM DUAL;

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

Line 7839: FROM DUAL;

7835: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7836: end if;
7837:
7838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7839: FROM DUAL;
7840: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7842: X_ROWID => l_rowid,
7843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7903: FROM DUAL;

7899: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7900: end if;
7901:
7902: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7903: FROM DUAL;
7904: hr_utility.trace(' inserting into Sublines -2KKKKK');
7905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7906: X_ROWID => l_rowid,
7907: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 7973: FROM DUAL;

7969: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7970: end if;
7971:
7972: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7973: FROM DUAL;
7974: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7975: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7976: X_ROWID => l_rowid,
7977: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8037: FROM DUAL;

8033: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8034: end if;
8035:
8036: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8037: FROM DUAL;
8038: hr_utility.trace(' inserting into Sublines -27777MMMN');
8039: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8040: X_ROWID => l_rowid,
8041: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8101: FROM DUAL;

8097: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8098: end if;
8099:
8100: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8101: FROM DUAL;
8102: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8103: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8104: X_ROWID => l_rowid,
8105: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8307: FROM DUAL;

8303: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8304: end if;
8305:
8306: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8307: FROM DUAL;
8308: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8309: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8310: X_ROWID => l_rowid,
8311: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8371: FROM DUAL;

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

Line 8444: FROM DUAL;

8440: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8441: end if;
8442:
8443: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8444: FROM DUAL;
8445: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8446: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8447: X_ROWID => l_rowid,
8448: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8508: FROM DUAL;

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

Line 8578: FROM DUAL;

8574: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8575: end if;
8576:
8577: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8578: FROM DUAL;
8579: hr_utility.trace(' inserting into Sublines -2JYUPA');
8580: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8581: X_ROWID => l_rowid,
8582: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8642: FROM DUAL;

8638: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8639: end if;
8640:
8641: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8642: FROM DUAL;
8643: hr_utility.trace(' inserting into Sublines -2NBMM');
8644: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8645: X_ROWID => l_rowid,
8646: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8706: FROM DUAL;

8702: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8703: end if;
8704:
8705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8706: FROM DUAL;
8707: hr_utility.trace(' inserting into Sublines -2TOPP');
8708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8709: X_ROWID => l_rowid,
8710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

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

8937: psp_payroll_lines
8938: where payroll_line_id = x_payroll_line_id));
8939:
8940: -- Inserting into PSP_SUB_LINES
8941: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8942: hr_utility.trace(' inserting into Sublines -2UISISI');
8943: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8944: X_ROWID => l_rowid,
8945: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

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

9120: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9121: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9122: END IF;
9123:
9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9125:
9126: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9127: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9128: (X_ROWID => l_rowid,