APPS.PSP_ENC_CREATE_LINES dependencies on PSP_ENC_PAYROLLS

Line 6383: FROM psp_enc_payrolls pep

6379: WHERE request_id = l_request_id;
6380:
6381: CURSOR enc_payrolls_cur IS
6382: SELECT pep.payroll_id
6383: FROM psp_enc_payrolls pep
6384: WHERE pep.business_group_id = l_business_group_id
6385: AND pep.set_of_books_id = l_set_of_books_id;
6386: BEGIN
6387: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Entering CEL_RANGE_CODE pactid: ' || pactid);

Line 8522: FROM psp_enc_payrolls pep

8518: AND fcr.request_id = pep.request_id;
8519:
8520: CURSOR enc_payroll_cur IS
8521: SELECT pep.inc_exc_flag
8522: FROM psp_enc_payrolls pep
8523: WHERE pep.payroll_id = p_payroll_id
8524: AND pep.business_group_id = l_business_group_id
8525: AND pep.set_of_books_id = l_set_of_books_id;
8526:

Line 8702: psp_enc_payrolls pep

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
8706: AND pepa.business_group_id = pep.business_group_id

Line 8759: psp_enc_payrolls pep

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
8763: AND pepa.business_group_id = pep.business_group_id

Line 8803: psp_enc_payrolls pep

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
8807: AND pepa.business_group_id = pep.business_group_id

Line 8830: psp_enc_payrolls pep,

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

Line 8880: psp_enc_payrolls pep,

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

Line 8935: psp_enc_payrolls pep

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
8939: AND pepa.business_group_id = pep.business_group_id