APPS.PSP_PAYTRN dependencies on PSP_PAYROLL_LINES

Line 351: FROM PSP_PAYROLL_LINES

347: g_pay_costs_rec get_pay_costs_csr%ROWTYPE;
348:
349: CURSOR check_payroll_lines_csr is
350: SELECT cost_id
351: FROM PSP_PAYROLL_LINES
352: WHERE cost_id = g_pay_costs_rec.cost_id;
353:
354: --Declare variable for above cursor
355:

Line 483: psp_payroll_lines ppl

479: ppl.payroll_action_type,
480: ppc.time_period_id,
481: ppc.parent_payroll_control_id
482: from psp_payroll_controls ppc,
483: psp_payroll_lines ppl
484: where ppc.run_id = l_run_id
485: and ppc.payroll_control_id = ppl.payroll_control_id
486: group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
487: fnd_lookup_values_vl fvl,

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 1465: --Insert a single line into psp_payroll_lines

1461: */
1462: IF g_non_active_flag <> 'E' then -- introduced for 2426343
1463: IF g_non_active_flag = 'Y' OR g_hire_zero_work_days = 'Y' OR g_all_holiday_zero_work_days = 'Y' THEN
1464:
1465: --Insert a single line into psp_payroll_lines
1466:
1467: hr_utility.trace('-pass 20');
1468:
1469: PSP_PAYROLL_LINES_PKG.INSERT_ROW (

Line 1469: PSP_PAYROLL_LINES_PKG.INSERT_ROW (

1465: --Insert a single line into psp_payroll_lines
1466:
1467: hr_utility.trace('-pass 20');
1468:
1469: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1470: X_ROWID => x_rowid,
1471: X_PAYROLL_LINE_ID => l_line_id ,
1472: X_PAYROLL_CONTROL_ID => l_export_id ,
1473: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,

Line 1543: PSP_PAYROLL_LINES_PKG.INSERT_ROW (

1539: ---End of changes made for Non active assignments: Done as part of Bug 1994421 -Zero Work Days Build -lveerubh
1540:
1541: hr_utility.trace('-pass 50');
1542:
1543: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1544: X_ROWID => x_rowid,
1545: X_PAYROLL_LINE_ID => l_line_id ,
1546: X_PAYROLL_CONTROL_ID => l_export_id ,
1547: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,

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 1936: from psp_payroll_lines

1932: set sublines_dr_amount = ( select sum(pay_amount)
1933: from psp_payroll_sub_lines
1934: where payroll_line_id in (
1935: select payroll_line_id
1936: from psp_payroll_lines
1937: where payroll_control_id =
1938: r_payroll_control_array.r_payroll_control_id(k)
1939: and dr_cr_flag = 'D')),
1940: sublines_cr_amount = ( select sum(pay_amount)

Line 1944: from psp_payroll_lines

1940: sublines_cr_amount = ( select sum(pay_amount)
1941: from psp_payroll_sub_lines
1942: where payroll_line_id in (
1943: select payroll_line_id
1944: from psp_payroll_lines
1945: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(k) and
1946: dr_cr_flag = 'C'))
1947: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(K);
1948:

Line 2850: FROM psp_payroll_lines

2846:
2847:
2848: CURSOR get_payroll_line_csr IS
2849: SELECT *
2850: FROM psp_payroll_lines
2851: WHERE payroll_line_id = x_payroll_line_id;
2852:
2853: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
2854:

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,

Line 8901: into psp_payroll_lines and psp_payroll_sub_lines

8897:
8898: Who When What
8899: lveerubh 15-SEP-2001 Creating the procedure
8900: This procedure inserts a single line
8901: into psp_payroll_lines and psp_payroll_sub_lines
8902: with sub line start date and sub line end date
8903: as date earned
8904: amakrish 01-Apr-2008 Changed the sub line start date and sub line end date
8905: to be least of date earned or payroll period end date

Line 8919: FROM psp_payroll_lines ppl

8915:
8916: CURSOR get_payroll_line_csr
8917: IS
8918: SELECT *
8919: FROM psp_payroll_lines ppl
8920: WHERE ppl.payroll_line_id = x_payroll_line_id;
8921:
8922: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8923: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237

Line 8937: psp_payroll_lines

8933: INTO l_tp_end_date
8934: FROM per_time_periods
8935: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8936: where payroll_control_id = (select payroll_control_id from
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;