APPS.PSP_PAYTRN dependencies on PSP_PAYROLL_LINES_S

Line 1376: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id

1372: raise FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 1559: UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;

1555:
1556: END IF;
1557: */
1558:
1559: UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;
1560:
1561: -- End of bug fix 2916848
1562:
1563: IF g_pay_costs_rec.debit_or_credit = 'D' then

Line 7828: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id

7824: if round(x_balance_amount, g_precision) <> 0.00 then
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,