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_PAYROLL_ASSIGNMENTS

Line 8949: INDEX(pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)

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
8953: ,psp_enc_payroll_assignments pepa

Line 8953: ,psp_enc_payroll_assignments pepa

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
8957: AND pep.business_group_id = p_business_group_id

Line 8973: FROM psp_enc_payroll_assignments pepa

8969: AND paaf.assignment_type = 'E'
8970: AND NOT EXISTS
8971: (
8972: SELECT pepa.assignment_id
8973: FROM psp_enc_payroll_assignments pepa
8974: WHERE pepa.business_group_id = p_business_group_id
8975: AND pepa.assignment_id = paaf.assignment_id
8976: )
8977: );

Line 9082: FROM psp_enc_payroll_assignments pepa,

9078: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9121: FROM psp_enc_payroll_assignments pepa,

9117: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9156: FROM psp_enc_payroll_assignments pepa,

9152: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9183: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)

9179: -- Modified the following statement for bug 9862281
9180: INSERT INTO psp_enc_changed_assignments
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,

Line 9188: psp_enc_payroll_assignments pepa,

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
9192: AND pepa.set_of_books_id = l_set_of_books_id

Line 9222: FROM psp_enc_payroll_assignments pepa,

9218: -- Added for bug 7188209
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

Line 9259: FROM psp_enc_payroll_assignments pepa,

9255: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9328: FROM psp_enc_payroll_assignments pepa,

9324: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9366: FROM psp_enc_payroll_assignments pepa,

9362: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9401: FROM psp_enc_payroll_assignments pepa,

9397: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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

Line 9428: index(Pepa PSP_ENC_PAYROLL_ASSIGNMENTS_N1)

9424: -- Modified the following statement for bug 9862281
9425: INSERT INTO psp_enc_changed_assignments
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,

Line 9433: psp_enc_payroll_assignments pepa,

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
9437: AND pepa.set_of_books_id = l_set_of_books_id

Line 9483: FROM psp_enc_payroll_assignments pepa,

9479: -- Added for bug 7188209
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

Line 9520: FROM psp_enc_payroll_assignments pepa,

9516: AND pa.effective_end_date >= (NVL((get_asg_pay_end_date(g_payroll_mode,p_payroll_action_id,pa.assignment_id,pa.business_group_id,pa.payroll_id) --13566809
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