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

8697: AND paa.action_status(+) = 'C'
8698: and ppa.date_earned between ptp.start_date and ptp.end_date
8699: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8700: AND NOT EXISTS (SELECT pepa.assignment_id
8701: FROM psp_enc_payroll_assignments pepa,
8702: psp_enc_payrolls pep
8703: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
8704: AND pepa.business_group_id = l_business_group_id
8705: AND pepa.set_of_books_id = l_set_of_books_id

Line 8758: FROM psp_enc_payroll_assignments pepa,

8754: AND paa.action_status(+) = 'C'
8755: and ppa.date_earned between ptp.start_date and ptp.end_date
8756: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8757: AND NOT EXISTS (SELECT pepa.assignment_id
8758: FROM psp_enc_payroll_assignments pepa,
8759: psp_enc_payrolls pep
8760: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
8761: AND pepa.business_group_id = l_business_group_id
8762: AND pepa.set_of_books_id = l_set_of_books_id

Line 8802: FROM psp_enc_payroll_assignments pepa,

8798: AND paa.action_status(+) = 'C'
8799: and ppa.date_earned between ptp.start_date and ptp.end_date
8800: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8801: AND EXISTS (SELECT pepa.assignment_id
8802: FROM psp_enc_payroll_assignments pepa,
8803: psp_enc_payrolls pep
8804: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
8805: AND pepa.business_group_id = l_business_group_id
8806: AND pepa.set_of_books_id = l_set_of_books_id

Line 8829: FROM psp_enc_payroll_assignments pepa,

8825:
8826: INSERT INTO psp_enc_changed_assignments
8827: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8828: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8829: FROM psp_enc_payroll_assignments pepa,
8830: psp_enc_payrolls pep,
8831: per_assignments_f pa
8832: WHERE pa.payroll_id = p_payroll_id
8833: AND pepa.business_group_id = l_business_group_id

Line 8879: FROM psp_enc_payroll_assignments pepa,

8875: -- Added for bug 7188209
8876: INSERT INTO psp_enc_changed_assignments
8877: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8878: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8879: FROM psp_enc_payroll_assignments pepa,
8880: psp_enc_payrolls pep,
8881: per_assignments_f pa
8882: WHERE pa.payroll_id = p_payroll_id
8883: AND pepa.business_group_id = l_business_group_id

Line 8934: FROM psp_enc_payroll_assignments pepa,

8930: AND paa.action_status(+) = 'C'
8931: and ppa.date_earned between ptp.start_date and ptp.end_date
8932: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date))
8933: AND NOT EXISTS (SELECT pepa.assignment_id
8934: FROM psp_enc_payroll_assignments pepa,
8935: psp_enc_payrolls pep
8936: WHERE pepa.enc_payroll_id = pep.enc_payroll_id
8937: AND pepa.business_group_id = l_business_group_id
8938: AND pepa.set_of_books_id = l_set_of_books_id