APPS.PAY_SE_RULES dependencies on HR_SOFT_CODING_KEYFLEX

Line 17: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE;

13: (p_assignment_id IN NUMBER
14: ,p_effective_date IN DATE
15: ,p_tax_unit_id OUT NOCOPY NUMBER ) IS
16:
17: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE;
18: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
19:
20: CURSOR c_local_unit_id IS
21: SELECT SCL.segment2 , business_group_id

Line 24: hr_soft_coding_keyflex SCL

20: CURSOR c_local_unit_id IS
21: SELECT SCL.segment2 , business_group_id
22: FROM
23: per_all_assignments_f PAA,
24: hr_soft_coding_keyflex SCL
25: WHERE ASSIGNMENT_ID = p_assignment_id
26: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
27: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
28:

Line 74: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;

70: ,p_third_party_id IN OUT NOCOPY NUMBER )
71: IS
72: l_third_party_id number;
73: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
74: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
75: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
76: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
77: l_pension_group_id hr_organization_information.org_information_id%TYPE;
78: l_pension_group hr_organization_information.org_information2%TYPE;

Line 715: hr_soft_coding_keyflex target,

711:
712: CURSOR c_local_unit_id(p_assignment_id NUMBER , p_effective_date DATE ) is
713: SELECT target.segment2
714: FROM
715: hr_soft_coding_keyflex target,
716: per_all_assignments_f ASSIGN,
717: fnd_id_flex_structures fstruct,
718: pay_legislation_rules leg
719: WHERE fstruct.id_flex_num = leg.rule_mode