[Home] [Help]
611: CURSOR assign_num_cur IS
612: SELECT paf.assignment_number,
613: ppf.employee_number
614: FROM
615: per_assignments_f paf,per_people_f ppf
616: WHERE paf.assignment_id =p_assignment_id
617: AND paf.person_id =ppf.person_id
618: AND p_effective_date between paf.effective_start_date and paf.effective_end_date
619: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
848: pay_element_entries_f pee,
849: pay_element_links_f pel,
850: pay_element_types_f pet,
851: psp_enc_elements peel,
852: per_assignments_f paf,
853: per_assignment_status_types past,
854: per_time_periods ptp
855: WHERE peev.element_entry_id = pee.element_entry_id
856: AND peev.effective_start_date <= paf.effective_end_date
953: pay_element_entries_f pee,
954: pay_element_links_f pel,
955: pay_element_types_f pet,
956: psp_enc_elements peel,
957: per_assignments_f paf,
958: per_assignment_status_types past
959: WHERE peev.element_entry_id = pee.element_entry_id
960: AND peev.effective_start_date <= paf.effective_end_date
961: AND peev.effective_end_date >= paf.effective_start_date
1049: CURSOR formula_date_cur IS
1050: SELECT GREATEST(pee.effective_start_date, paf.effective_start_date, ff.effective_start_date) start_date,
1051: LEAST(pee.effective_end_date, paf.effective_end_date, ff.effective_end_date) end_date
1052: FROM ff_formulas_f ff,
1053: per_assignments_f paf,
1054: pay_element_entries_f pee
1055: WHERE formula_id = l_formula_id
1056: AND paf.assignment_id = p_assignment_id
1057: AND pee.assignment_id = p_assignment_id
4139: CURSOR odls_cur IS
4140: SELECT GREATEST(l_min_start_date, paf.effective_start_date, schedule_begin_date) schedule_begin_date,
4141: LEAST(l_max_end_date, paf.effective_end_date, schedule_end_date) schedule_end_date,
4142: SUM(schedule_percent) schedule_percent
4143: FROM per_assignments_f paf,
4144: psp_default_labor_schedules pdls
4145: WHERE paf.assignment_id = p_assignment_id
4146: AND l_min_start_date <= paf.effective_end_date
4147: AND l_max_end_date >= paf.effective_start_date
6866: pc.costing_debit_or_credit
6867: FROM PAY_ELEMENT_ENTRIES_F pee,
6868: PAY_ELEMENT_LINKS_F pel,
6869: PAY_ELEMENT_TYPES_F pet,
6870: PER_ASSIGNMENTS_F pa,
6871: PAY_ELEMENT_CLASSIFICATIONS pc
6872: WHERE pee.assignment_id = p_assignment_id
6873: AND pa.assignment_id = p_assignment_id
6874: AND pee.effective_end_date >= pa.effective_start_date
9068:
9069: INSERT INTO psp_enc_changed_assignments
9070: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9071: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9072: FROM per_assignments_f pa
9073: WHERE pa.payroll_id = p_payroll_id
9074: AND pa.assignment_type = 'E'
9075: AND pa.business_group_id = l_business_group_id
9076: -- AND pa.effective_end_date >= l_enc_begin_date
9109:
9110: INSERT INTO psp_enc_changed_assignments
9111: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9112: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9113: FROM per_assignments_f pa
9114: WHERE pa.payroll_id = p_payroll_id
9115: AND pa.assignment_type = 'E'
9116: AND pa.business_group_id = l_business_group_id
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
9142:
9143: INSERT INTO psp_enc_changed_assignments
9144: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9145: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9146: FROM per_assignments_f pa
9147: WHERE pa.payroll_id = p_payroll_id
9148: AND pa.assignment_type = 'E'
9149: AND pa.business_group_id = l_business_group_id
9150: -- AND pa.effective_end_date >= l_enc_begin_date -- Commenting this in the fix 12769510 as it is found to be commented in 11i code
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,
9188: psp_enc_payroll_assignments pepa,
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
9193: AND pepa.assignment_id = pa.assignment_id
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
9228: AND pepa.assignment_id = pa.assignment_id
9245:
9246: INSERT INTO psp_enc_changed_assignments
9247: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9248: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9249: FROM per_assignments_f pa
9250: WHERE pa.payroll_id = p_payroll_id
9251: AND pa.assignment_type = 'E'
9252: AND pa.business_group_id = l_business_group_id
9253: -- AND pa.effective_end_date >= l_enc_begin_date -- Commenting this in the fix 12769510 as it is found to be commented in 11i code
9314:
9315: INSERT INTO psp_enc_changed_assignments
9316: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9317: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9318: FROM per_assignments_f pa
9319: WHERE pa.payroll_id = p_payroll_id
9320: AND pa.assignment_type = 'E'
9321: AND pa.business_group_id = l_business_group_id
9322: -- AND pa.effective_end_date >= l_enc_begin_date
9354:
9355: INSERT INTO psp_enc_changed_assignments
9356: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9357: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
9358: FROM per_assignments_f pa
9359: WHERE pa.payroll_id = p_payroll_id
9360: AND pa.assignment_type = 'E'
9361: AND pa.business_group_id = l_business_group_id
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
9387:
9388: INSERT INTO psp_enc_changed_assignments
9389: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9390: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9391: FROM per_assignments_f pa
9392: WHERE pa.payroll_id = p_payroll_id
9393: AND pa.assignment_type = 'E'
9394: AND pa.business_group_id = l_business_group_id
9395: -- AND pa.effective_end_date >= l_enc_begin_date -- Commenting this in the fix 12769510 as it is found to be commented in 11i code
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,
9433: psp_enc_payroll_assignments pepa,
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
9438: AND pepa.assignment_id = pa.assignment_id
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
9489: AND pepa.assignment_id = pa.assignment_id
9506:
9507: INSERT INTO psp_enc_changed_assignments
9508: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
9509: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
9510: FROM per_assignments_f pa
9511: WHERE pa.payroll_id = p_payroll_id
9512: AND pa.assignment_type = 'E'
9513: AND pa.business_group_id = l_business_group_id
9514: -- AND pa.effective_end_date >= l_enc_begin_date -- Commenting this in the fix 12769510 as it is found to be commented in 11i code
10497: CURSOR asg_org_cur IS
10498: SELECT organization_id,
10499: effective_start_date,
10500: NVL(LEAD(effective_start_date - 1) OVER (ORDER BY effective_end_date), LEAST(l_max_end_date, effective_end_date))
10501: FROM per_assignments_f paf
10502: WHERE assignment_id = p_assignment_id
10503: AND payroll_id = p_payroll_id
10504: AND effective_start_date <= LEAST(l_max_end_date, g_enc_org_end_date)
10505: ANd effective_end_date >= l_min_start_date
10503: AND payroll_id = p_payroll_id
10504: AND effective_start_date <= LEAST(l_max_end_date, g_enc_org_end_date)
10505: ANd effective_end_date >= l_min_start_date
10506: AND effective_start_date = (SELECT MIN(paf2.effective_start_date)
10507: FROM per_assignments_f paf2
10508: WHERE paf2.assignment_id = p_assignment_id
10509: AND paf2.payroll_id = paf.payroll_id
10510: AND paf2.organization_id = paf.organization_id
10511: AND paf2.effective_start_date >= paf.effective_start_date);