[Home] [Help]
411: CURSOR assign_num_cur IS
412: SELECT paf.assignment_number,
413: ppf.employee_number
414: FROM
415: per_assignments_f paf,per_people_f ppf
416: WHERE paf.assignment_id =p_assignment_id
417: AND paf.person_id =ppf.person_id
418: AND p_effective_date between paf.effective_start_date and paf.effective_end_date
419: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;
646: pay_element_entries_f pee,
647: pay_element_links_f pel,
648: pay_element_types_f pet,
649: psp_enc_elements peel,
650: per_assignments_f paf,
651: per_assignment_status_types past,
652: per_time_periods ptp
653: WHERE peev.element_entry_id = pee.element_entry_id
654: AND peev.effective_start_date <= paf.effective_end_date
751: pay_element_entries_f pee,
752: pay_element_links_f pel,
753: pay_element_types_f pet,
754: psp_enc_elements peel,
755: per_assignments_f paf,
756: per_assignment_status_types past
757: WHERE peev.element_entry_id = pee.element_entry_id
758: AND peev.effective_start_date <= paf.effective_end_date
759: AND peev.effective_end_date >= paf.effective_start_date
846: CURSOR formula_date_cur IS
847: SELECT GREATEST(pee.effective_start_date, paf.effective_start_date, ff.effective_start_date) start_date,
848: LEAST(pee.effective_end_date, paf.effective_end_date, ff.effective_end_date) end_date
849: FROM ff_formulas_f ff,
850: per_assignments_f paf,
851: pay_element_entries_f pee
852: WHERE formula_id = l_formula_id
853: AND paf.assignment_id = p_assignment_id
854: AND pee.assignment_id = p_assignment_id
3904: CURSOR odls_cur IS
3905: SELECT GREATEST(l_min_start_date, paf.effective_start_date, schedule_begin_date) schedule_begin_date,
3906: LEAST(l_max_end_date, paf.effective_end_date, schedule_end_date) schedule_end_date,
3907: SUM(schedule_percent) schedule_percent
3908: FROM per_assignments_f paf,
3909: psp_default_labor_schedules pdls
3910: WHERE paf.assignment_id = p_assignment_id
3911: AND l_min_start_date <= paf.effective_end_date
3912: AND l_max_end_date >= paf.effective_start_date
6600: pc.costing_debit_or_credit
6601: FROM PAY_ELEMENT_ENTRIES_F pee,
6602: PAY_ELEMENT_LINKS_F pel,
6603: PAY_ELEMENT_TYPES_F pet,
6604: PER_ASSIGNMENTS_F pa,
6605: PAY_ELEMENT_CLASSIFICATIONS pc
6606: WHERE pee.assignment_id = p_assignment_id
6607: AND pa.assignment_id = p_assignment_id
6608: AND pee.effective_end_date >= pa.effective_start_date
8678:
8679: INSERT INTO psp_enc_changed_assignments
8680: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8681: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8682: FROM per_assignments_f pa
8683: WHERE pa.payroll_id = p_payroll_id
8684: AND pa.assignment_type = 'E'
8685: AND pa.business_group_id = l_business_group_id
8686: -- AND pa.effective_end_date >= l_enc_begin_date
8737:
8738: INSERT INTO psp_enc_changed_assignments
8739: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8740: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'CR', p_payroll_action_id
8741: FROM per_assignments_f pa
8742: WHERE pa.payroll_id = p_payroll_id
8743: AND pa.assignment_type = 'E'
8744: AND pa.business_group_id = l_business_group_id
8745: AND pa.effective_end_date >= (NVL((SELECT /*+ use_nl(PTP) */ Max(ptp.end_date)
8779:
8780: INSERT INTO psp_enc_changed_assignments
8781: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8782: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8783: FROM per_assignments_f pa
8784: WHERE pa.payroll_id = p_payroll_id
8785: AND pa.assignment_type = 'E'
8786: AND pa.business_group_id = l_business_group_id
8787: AND pa.effective_end_date >= l_enc_begin_date
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
8835: AND pepa.assignment_id = pa.assignment_id
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
8885: AND pepa.assignment_id = pa.assignment_id
8911:
8912: INSERT INTO psp_enc_changed_assignments
8913: (request_id, payroll_id, assignment_id, change_type, payroll_action_id)
8914: SELECT DISTINCT l_request_id, p_payroll_id, pa.assignment_id, 'ZZ', p_payroll_action_id
8915: FROM per_assignments_f pa
8916: WHERE pa.payroll_id = p_payroll_id
8917: AND pa.assignment_type = 'E'
8918: AND pa.business_group_id = l_business_group_id
8919: AND pa.effective_end_date >= l_enc_begin_date
9867: CURSOR asg_org_cur IS
9868: SELECT organization_id,
9869: effective_start_date,
9870: NVL(LEAD(effective_start_date - 1) OVER (ORDER BY effective_end_date), LEAST(l_max_end_date, effective_end_date))
9871: FROM per_assignments_f paf
9872: WHERE assignment_id = p_assignment_id
9873: AND payroll_id = p_payroll_id
9874: AND effective_start_date <= LEAST(l_max_end_date, g_enc_org_end_date)
9875: ANd effective_end_date >= l_min_start_date
9873: AND payroll_id = p_payroll_id
9874: AND effective_start_date <= LEAST(l_max_end_date, g_enc_org_end_date)
9875: ANd effective_end_date >= l_min_start_date
9876: AND effective_start_date = (SELECT MIN(paf2.effective_start_date)
9877: FROM per_assignments_f paf2
9878: WHERE paf2.assignment_id = p_assignment_id
9879: AND paf2.payroll_id = paf.payroll_id
9880: AND paf2.organization_id = paf.organization_id
9881: AND paf2.effective_start_date >= paf.effective_start_date);