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 PSP_PAYROLL_LINES

Line 349: FROM PSP_PAYROLL_LINES

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

Line 481: psp_payroll_lines ppl

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

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

1404: */
1405: IF g_non_active_flag <> 'E' then -- introduced for 2426343
1406: IF g_non_active_flag = 'Y' OR g_hire_zero_work_days = 'Y' OR g_all_holiday_zero_work_days = 'Y' THEN
1407:
1408: --Insert a single line into psp_payroll_lines
1409:
1410: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1411: X_ROWID => x_rowid,
1412: X_PAYROLL_LINE_ID => l_line_id ,

Line 1410: PSP_PAYROLL_LINES_PKG.INSERT_ROW (

1406: IF g_non_active_flag = 'Y' OR g_hire_zero_work_days = 'Y' OR g_all_holiday_zero_work_days = 'Y' THEN
1407:
1408: --Insert a single line into psp_payroll_lines
1409:
1410: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1411: X_ROWID => x_rowid,
1412: X_PAYROLL_LINE_ID => l_line_id ,
1413: X_PAYROLL_CONTROL_ID => l_export_id ,
1414: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,

Line 1482: PSP_PAYROLL_LINES_PKG.INSERT_ROW (

1478: ---End of changes made for Non active assignments: Done as part of Bug 1994421 -Zero Work Days Build -lveerubh
1479:
1480:
1481:
1482: PSP_PAYROLL_LINES_PKG.INSERT_ROW (
1483: X_ROWID => x_rowid,
1484: X_PAYROLL_LINE_ID => l_line_id ,
1485: X_PAYROLL_CONTROL_ID => l_export_id ,
1486: X_SET_OF_BOOKS_ID => l_resp_set_of_books_id ,

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

1858: set sublines_dr_amount = ( select sum(pay_amount)
1859: from psp_payroll_sub_lines
1860: where payroll_line_id in (
1861: select payroll_line_id
1862: from psp_payroll_lines
1863: where payroll_control_id =
1864: r_payroll_control_array.r_payroll_control_id(k)
1865: and dr_cr_flag = 'D')),
1866: sublines_cr_amount = ( select sum(pay_amount)

Line 1870: from psp_payroll_lines

1866: sublines_cr_amount = ( select sum(pay_amount)
1867: from psp_payroll_sub_lines
1868: where payroll_line_id in (
1869: select payroll_line_id
1870: from psp_payroll_lines
1871: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(k) and
1872: dr_cr_flag = 'C'))
1873: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(K);
1874:

Line 2776: FROM psp_payroll_lines

2772:
2773:
2774: CURSOR get_payroll_line_csr IS
2775: SELECT *
2776: FROM psp_payroll_lines
2777: WHERE payroll_line_id = x_payroll_line_id;
2778:
2779: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
2780:

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,

Line 8827: into psp_payroll_lines and psp_payroll_sub_lines

8823:
8824: Who When What
8825: lveerubh 15-SEP-2001 Creating the procedure
8826: This procedure inserts a single line
8827: into psp_payroll_lines and psp_payroll_sub_lines
8828: with sub line start date and sub line end date
8829: as date earned
8830: amakrish 01-Apr-2008 Changed the sub line start date and sub line end date
8831: to be least of date earned or payroll period end date

Line 8845: FROM psp_payroll_lines ppl

8841:
8842: CURSOR get_payroll_line_csr
8843: IS
8844: SELECT *
8845: FROM psp_payroll_lines ppl
8846: WHERE ppl.payroll_line_id = x_payroll_line_id;
8847:
8848: g_payroll_line_rec get_payroll_line_csr%ROWTYPE;
8849: l_tp_end_date per_time_periods.end_date%TYPE; -- BUG 6886237

Line 8863: psp_payroll_lines

8859: INTO l_tp_end_date
8860: FROM per_time_periods
8861: WHERE time_period_id = (select time_period_id from psp_payroll_controls
8862: where payroll_control_id = (select payroll_control_id from
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;