APPS.PAY_IN_TERMINATION_PKG dependencies on PER_ASSIGNMENTS_F

Line 8: g_assignment_id per_assignments_f.assignment_id%TYPE;

4: g_package CONSTANT VARCHAR2(100) := 'pay_in_termination_pkg.' ;
5: g_debug BOOLEAN ;
6: g_legislation_code CONSTANT VARCHAR2(2) := 'IN';
7:
8: g_assignment_id per_assignments_f.assignment_id%TYPE;
9: g_payroll_id pay_payrolls_f.payroll_id%TYPE;
10: g_hire_date per_people_f.start_date%TYPE;
11: g_notified_date per_periods_of_service.NOTIFIED_TERMINATION_DATE%TYPE;
12:

Line 615: ,per_assignments_f paf

611: ,pos.date_start
612: ,pos.leaving_reason
613: ,pos.notified_termination_date
614: FROM per_periods_of_service pos
615: ,per_assignments_f paf
616: ,per_people_f ppf
617: WHERE pos.period_of_service_id = p_period_of_service_id
618: AND pos.business_group_id = p_business_group_id
619: AND pos.period_of_service_id = paf.period_of_service_id

Line 771: per_assignments_f paf

767: SELECT pel.element_link_id
768: ,pet.element_type_id
769: FROM pay_element_links_f pel,
770: pay_element_types_f pet,
771: per_assignments_f paf
772: WHERE pet.element_name = p_element_name
773: AND paf.assignment_id = g_assignment_id
774: AND pet.element_type_id = pel.element_type_id
775: AND (pel.payroll_id = g_payroll_id or pel.payroll_id IS NULL)

Line 1044: FROM per_assignments_f asg

1040: CURSOR csr_asg_details
1041: IS
1042: SELECT asg.business_group_id
1043: ,asg.payroll_id
1044: FROM per_assignments_f asg
1045: WHERE asg.assignment_id = p_assignment_id
1046: AND asg.primary_flag = 'Y'
1047: AND p_effective_date BETWEEN asg.effective_start_date
1048: AND asg.effective_end_date ;

Line 1175: FROM per_assignments_f asg

1171: CURSOR csr_asg_details
1172: IS
1173: SELECT asg.business_group_id
1174: ,asg.payroll_id
1175: FROM per_assignments_f asg
1176: WHERE asg.assignment_id = p_assignment_id
1177: AND asg.primary_flag = 'Y'
1178: AND p_effective_date BETWEEN asg.effective_start_date
1179: AND asg.effective_end_date ;

Line 1380: FROM per_assignments_f asg

1376: CURSOR csr_asg_details
1377: IS
1378: SELECT asg.business_group_id
1379: ,asg.payroll_id
1380: FROM per_assignments_f asg
1381: WHERE asg.assignment_id = p_assignment_id
1382: AND asg.primary_flag = 'Y'
1383: AND p_effective_date BETWEEN asg.effective_start_date
1384: AND asg.effective_end_date ;

Line 1482: FROM per_assignments_f asg

1478:
1479: CURSOR csr_asg_details
1480: IS
1481: SELECT scl.segment8
1482: FROM per_assignments_f asg
1483: ,hr_soft_coding_keyflex scl
1484: WHERE asg.assignment_id = g_assignment_id
1485: AND asg.primary_flag = 'Y'
1486: AND p_actual_termination_date

Line 1769: FROM per_assignments_f paf

1765:
1766: CURSOR csr_emp_catg IS
1767: SELECT NVL(paf.employee_category,'IN_DEF'),
1768: paf.notice_period,paf.notice_period_uom
1769: FROM per_assignments_f paf
1770: WHERE paf.assignment_id = g_assignment_id
1771: AND p_actual_termination_date BETWEEN paf.effective_start_date
1772: AND paf.effective_end_date;
1773:

Line 1781: l_emp_category per_assignments_f.employee_category%TYPE;

1777: WHERE hoi.organization_id = p_business_group_id
1778: AND hoi.org_information_context = 'PER_IN_NOTICE_DF'
1779: AND hoi.org_information1 = p_emp_category;
1780:
1781: l_emp_category per_assignments_f.employee_category%TYPE;
1782: l_notice_duration NUMBER;
1783: l_notice_uom VARCHAR2(2);
1784: l_shortfall NUMBER;
1785: l_message VARCHAR2(1000);

Line 3551: ,per_assignments_f paf

3547: SELECT ppf.per_information15
3548: ,pos.pds_information1
3549: ,pos.pds_information2
3550: FROM per_periods_of_service pos
3551: ,per_assignments_f paf
3552: ,per_people_f ppf
3553: ,hr_soft_coding_keyflex scl
3554: WHERE pos.period_of_service_id = p_period_of_service_id
3555: AND pos.business_group_id = p_business_group_id