APPS.PSP_PAYTRN dependencies on PSP_PAYROLL_LINES_S

Line 1415: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id

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

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

1617:
1618: END IF;
1619: */
1620:
1621: UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;
1622:
1623: -- End of bug fix 2916848
1624:
1625: IF g_pay_costs_rec.debit_or_credit = 'D' then

Line 7902: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id

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