[Home] [Help]
703: paf.effective_end_date
704: FROM per_pay_proposals ppp,
705: pay_input_values_f piv,
706: per_pay_bases ppb,
707: per_all_assignments_f paf,
708: per_assignment_status_types past
709: WHERE paf.assignment_id =p_assignment_id
710: AND ( ppp.change_date BETWEEN paf.effective_start_date AND paf.effective_end_date
711: OR ppp.change_date = (SELECT MAX(ppp1.change_date)
1385: 'Y',
1386: 0,
1387: NULL
1388: FROM per_time_periods ptp,
1389: per_all_assignments_f paf,
1390: per_assignment_status_types past
1391: WHERE ptp.payroll_id = p_payroll_id
1392: AND paf.assignment_id = p_assignment_id
1393: AND ptp.start_date <= paf.effective_end_date
1402: ORDER BY 1, 4;
1403:
1404: CURSOR c_person_id IS
1405: SELECT paf.person_id
1406: FROM per_all_assignments_f paf
1407: WHERE paf.assignment_id =p_assignment_id
1408: AND ROWNUM=1;
1409:
1410: l_project_number pa_projects_all.segment1%TYPE;
1487: l_max_end_date DATE;
1488:
1489: CURSOR asg_number_cur IS
1490: SELECT organization_id
1491: FROM per_all_assignments_f
1492: WHERE assignment_id = p_assignment_id
1493: AND payroll_id = p_payroll_id
1494: AND effective_end_date >= l_asg_start_date
1495: AND ROWNUM = 1;
6534: l_assignment_id NUMBER(15);
6535: l_payroll_id NUMBER(15);
6536: l_person_id NUMBER(15);
6537: l_organization_id NUMBER(15);
6538: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
6539: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
6540: l_full_name per_all_people_f.full_name%TYPE;
6541: l_organization_name hr_organization_units.name%TYPE;
6542: l_process_mode VARCHAR2(15);
6676: CURSOR asg_number_cur (p_effective_date IN DATE) IS
6677: SELECT assignment_number,
6678: person_id,
6679: organization_id
6680: FROM per_all_assignments_f
6681: WHERE assignment_id = l_assignment_id
6682: AND payroll_id = l_payroll_id
6683: AND effective_end_date >= p_effective_date
6684: AND ROWNUM = 1;
6765: WHERE piv.input_value_id = pee.input_value_id
6766: AND SUBSTR(piv.uom, 1, 1) = 'H'));
6767:
6768:
6769: TYPE payid_tab IS TABLE OF per_all_assignments_f.payroll_id%TYPE INDEX BY BINARY_INTEGER;
6770: TYPE asgid_tab IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;
6771: TYPE term_date_tab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
6772: TYPE t_asg_id_rec IS RECORD
6773: (payroll_array payid_tab,
6766: AND SUBSTR(piv.uom, 1, 1) = 'H'));
6767:
6768:
6769: TYPE payid_tab IS TABLE OF per_all_assignments_f.payroll_id%TYPE INDEX BY BINARY_INTEGER;
6770: TYPE asgid_tab IS TABLE OF per_all_assignments_f.assignment_id%TYPE INDEX BY BINARY_INTEGER;
6771: TYPE term_date_tab IS TABLE OF DATE INDEX BY BINARY_INTEGER;
6772: TYPE t_asg_id_rec IS RECORD
6773: (payroll_array payid_tab,
6774: asg_array asgid_tab,
8478: l_payroll_action_id NUMBER(15);
8479: l_payroll_id NUMBER(15);
8480: l_person_id NUMBER(15);
8481: l_organization_id NUMBER(15);
8482: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
8483: l_payroll_name pay_all_payrolls_f.payroll_name%TYPE;
8484: l_full_name per_all_people_f.full_name%TYPE;
8485: l_organization_name hr_organization_units.name%TYPE;
8486: l_process_description fnd_concurrent_programs_tl.user_concurrent_program_name%TYPE;
8546: CURSOR asg_number_cur (p_start_date IN DATE) IS
8547: SELECT assignment_number,
8548: person_id,
8549: organization_id
8550: FROM per_all_assignments_f
8551: WHERE assignment_id = l_assignment_id
8552: AND payroll_id = NVL(l_payroll_id, p_payroll_id)
8553: AND effective_end_date >= p_start_date
8554: AND ROWNUM = 1;
9467: CURSOR asg_cur (p_person_id IN NUMBER,
9468: p_assignment_id IN NUMBER) IS
9469: SELECT DISTINCT pepa.assignment_id
9470: FROM psp_enc_process_assignments pepa,
9471: per_all_assignments_f paf
9472: WHERE pepa.payroll_action_id = p_payroll_action_id
9473: AND paf.person_id = p_person_id
9474: AND paf.assignment_id = pepa.assignment_id
9475: AND ( p_assignment_id IS NULL