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_ENC_CREATE_LINES dependencies on PSP_ENC_PAYROLLS

Line 6639: FROM psp_enc_payrolls pep

6635: WHERE request_id = l_request_id;
6636:
6637: CURSOR enc_payrolls_cur IS
6638: SELECT pep.payroll_id
6639: FROM psp_enc_payrolls pep
6640: WHERE pep.business_group_id = l_business_group_id
6641: AND pep.set_of_books_id = l_set_of_books_id;
6642: BEGIN
6643: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);

Line 8846: FROM psp_enc_payrolls pep

8842: AND fcr.request_id = pep.request_id;
8843:
8844: CURSOR enc_payroll_cur IS
8845: SELECT pep.inc_exc_flag
8846: FROM psp_enc_payrolls pep
8847: WHERE pep.payroll_id = p_payroll_id
8848: AND pep.business_group_id = l_business_group_id
8849: AND pep.set_of_books_id = l_set_of_books_id;
8850:

Line 8948: INDEX(pep PSP_ENC_PAYROLLS_N1)

8944: AND request_id = l_request_id
8945: AND assignment_id IN
8946: (
8947: SELECT /*+ ORDERED
8948: INDEX(pep PSP_ENC_PAYROLLS_N1)
8949: INDEX(pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
8950: */
8951: pepa.assignment_id
8952: FROM psp_enc_payrolls pep

Line 8952: FROM psp_enc_payrolls pep

8948: INDEX(pep PSP_ENC_PAYROLLS_N1)
8949: INDEX(pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
8950: */
8951: pepa.assignment_id
8952: FROM psp_enc_payrolls pep
8953: ,psp_enc_payroll_assignments pepa
8954: WHERE pep.payroll_id = p_payroll_id
8955: AND pep.inc_exc_flag = 'Y'
8956: AND pep.enc_payroll_id = pepa.enc_payroll_id

Line 8963: FROM psp_enc_payrolls pep

8959: SELECT /*+ORDERED
8960: NO_USE_MERGE(paaf) */
8961: DISTINCT
8962: paaf.assignment_id
8963: FROM psp_enc_payrolls pep
8964: ,per_all_assignments_f paaf
8965: WHERE pep.inc_exc_flag = 'N'
8966: AND pep.payroll_id = paaf.payroll_id
8967: AND pep.payroll_id = p_payroll_id

Line 9083: psp_enc_payrolls pep

9079: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9080: ),l_enc_begin_date))
9081: AND NOT EXISTS (SELECT pepa.assignment_id
9082: FROM psp_enc_payroll_assignments pepa,
9083: psp_enc_payrolls pep
9084: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9085: AND pepa.business_group_id = l_business_group_id
9086: AND pepa.set_of_books_id = l_set_of_books_id
9087: AND pepa.business_group_id = pep.business_group_id

Line 9122: psp_enc_payrolls pep

9118: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9119: ),l_enc_begin_date))
9120: AND NOT EXISTS (SELECT pepa.assignment_id
9121: FROM psp_enc_payroll_assignments pepa,
9122: psp_enc_payrolls pep
9123: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9124: AND pepa.business_group_id = l_business_group_id
9125: AND pepa.set_of_books_id = l_set_of_books_id
9126: AND pepa.business_group_id = pep.business_group_id

Line 9157: psp_enc_payrolls pep

9153: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9154: ),l_enc_begin_date))
9155: AND EXISTS (SELECT pepa.assignment_id
9156: FROM psp_enc_payroll_assignments pepa,
9157: psp_enc_payrolls pep
9158: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9159: AND pepa.business_group_id = l_business_group_id
9160: AND pepa.set_of_books_id = l_set_of_books_id
9161: AND pepa.business_group_id = pep.business_group_id

Line 9185: INDEX(pep PSP_ENC_PAYROLLS_N1) */

9181: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9182: SELECT /*+
9183: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9184: index(PA PER_ASSIGNMENTS_F_PK)
9185: INDEX(pep PSP_ENC_PAYROLLS_N1) */
9186: DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9187: FROM psp_enc_payrolls pep,
9188: psp_enc_payroll_assignments pepa,
9189: per_assignments_f pa

Line 9187: FROM psp_enc_payrolls pep,

9183: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9184: index(PA PER_ASSIGNMENTS_F_PK)
9185: INDEX(pep PSP_ENC_PAYROLLS_N1) */
9186: DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9187: FROM psp_enc_payrolls pep,
9188: psp_enc_payroll_assignments pepa,
9189: per_assignments_f pa
9190: WHERE pa.payroll_id = p_payroll_id
9191: AND pepa.business_group_id = l_business_group_id

Line 9223: psp_enc_payrolls pep,

9219: INSERT INTO psp_enc_changed_assignments
9220: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9221: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9222: FROM psp_enc_payroll_assignments pepa,
9223: psp_enc_payrolls pep,
9224: per_assignments_f pa
9225: WHERE pa.payroll_id = p_payroll_id
9226: AND pepa.business_group_id = l_business_group_id
9227: AND pepa.set_of_books_id = l_set_of_books_id

Line 9260: psp_enc_payrolls pep

9256: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9257: ),l_enc_begin_date))
9258: AND NOT EXISTS (SELECT pepa.assignment_id
9259: FROM psp_enc_payroll_assignments pepa,
9260: psp_enc_payrolls pep
9261: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9262: AND pepa.business_group_id = l_business_group_id
9263: AND pepa.set_of_books_id = l_set_of_books_id
9264: AND pepa.business_group_id = pep.business_group_id

Line 9329: psp_enc_payrolls pep

9325: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9326: ),l_enc_begin_date))
9327: AND NOT EXISTS (SELECT pepa.assignment_id
9328: FROM psp_enc_payroll_assignments pepa,
9329: psp_enc_payrolls pep
9330: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9331: AND pepa.business_group_id = l_business_group_id
9332: AND pepa.set_of_books_id = l_set_of_books_id
9333: AND pepa.business_group_id = pep.business_group_id

Line 9367: psp_enc_payrolls pep

9363: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9364: ),l_enc_begin_date))
9365: AND NOT EXISTS (SELECT pepa.assignment_id
9366: FROM psp_enc_payroll_assignments pepa,
9367: psp_enc_payrolls pep
9368: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9369: AND pepa.business_group_id = l_business_group_id
9370: AND pepa.set_of_books_id = l_set_of_books_id
9371: AND pepa.business_group_id = pep.business_group_id

Line 9402: psp_enc_payrolls pep

9398: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9399: ),l_enc_begin_date))
9400: AND EXISTS (SELECT pepa.assignment_id
9401: FROM psp_enc_payroll_assignments pepa,
9402: psp_enc_payrolls pep
9403: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9404: AND pepa.business_group_id = l_business_group_id
9405: AND pepa.set_of_books_id = l_set_of_books_id
9406: AND pepa.business_group_id = pep.business_group_id

Line 9430: INDEX(pep PSP_ENC_PAYROLLS_N1) */

9426: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9427: SELECT /*+
9428: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9429: index(PA PER_ASSIGNMENTS_F_PK)
9430: INDEX(pep PSP_ENC_PAYROLLS_N1) */
9431: DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9432: FROM psp_enc_payrolls pep,
9433: psp_enc_payroll_assignments pepa,
9434: per_assignments_f pa

Line 9432: FROM psp_enc_payrolls pep,

9428: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)
9429: index(PA PER_ASSIGNMENTS_F_PK)
9430: INDEX(pep PSP_ENC_PAYROLLS_N1) */
9431: DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9432: FROM psp_enc_payrolls pep,
9433: psp_enc_payroll_assignments pepa,
9434: per_assignments_f pa
9435: WHERE pa.payroll_id = p_payroll_id
9436: AND pepa.business_group_id = l_business_group_id

Line 9484: psp_enc_payrolls pep,

9480: INSERT INTO psp_enc_changed_assignments
9481: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9482: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9483: FROM psp_enc_payroll_assignments pepa,
9484: psp_enc_payrolls pep,
9485: per_assignments_f pa
9486: WHERE pa.payroll_id = p_payroll_id
9487: AND pepa.business_group_id = l_business_group_id
9488: AND pepa.set_of_books_id = l_set_of_books_id

Line 9521: psp_enc_payrolls pep

9517: -- AND ptp.time_period_id = ppa.time_period_id -- Added for bug 9862281 -- Commented for the Bug 12647364
9518: ),l_enc_begin_date))
9519: AND NOT EXISTS (SELECT pepa.assignment_id
9520: FROM psp_enc_payroll_assignments pepa,
9521: psp_enc_payrolls pep
9522: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
9523: AND pepa.business_group_id = l_business_group_id
9524: AND pepa.set_of_books_id = l_set_of_books_id
9525: AND pepa.business_group_id = pep.business_group_id