[Home] [Help]
12: (p_assignment_id IN NUMBER
13: ,p_effective_date IN DATE
14: ,p_tax_unit_id OUT NOCOPY NUMBER ) IS
15:
16: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
17: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
18:
19: CURSOR c_local_unit_id IS
20: SELECT SCL.segment2 , business_group_id
19: CURSOR c_local_unit_id IS
20: SELECT SCL.segment2 , business_group_id
21: FROM
22: per_all_assignments_f PAA ,
23: hr_soft_coding_keyflex SCL
24: WHERE ASSIGNMENT_ID = p_assignment_id
25: AND PAA.soft_coding_keyflex_id = SCL.soft_coding_keyflex_id
26: AND p_effective_date BETWEEN PAA.effective_start_date AND PAA.effective_end_date ;
27: CURSOR c_tax_unit_id (p_business_group_id NUMBER , p_organization_id NUMBER) IS
63: ,p_third_party_id IN OUT NOCOPY NUMBER )
64: IS
65: l_third_party_id number;
66: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;
67: l_local_unit_id hr_soft_coding_keyflex.SEGMENT2%TYPE ;
68: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;
69: l_tax_unit_id hr_organization_units.organization_id%TYPE ;
70: l_pension_group_id hr_organization_information.org_information_id%TYPE;
71: l_pension_group hr_organization_information.org_information2%TYPE;
139:
140: CURSOR c_local_unit_id(P_ASG_ACT_ID NUMBER) is
141: SELECT target.segment2 , ASSIGN.business_group_id
142: FROM
143: hr_soft_coding_keyflex target,
144: per_all_assignments ASSIGN,
145: fnd_id_flex_structures fstruct,
146: pay_legislation_rules leg,
147: pay_assignment_actions pac
341:
342: CURSOR get_details(P_ASG_ACT_ID NUMBER) is
343: SELECT nvl(target.segment8, '1')
344: FROM
345: hr_soft_coding_keyflex target,
346: per_all_assignments ASSIGN,
347: fnd_id_flex_structures fstruct,
348: pay_legislation_rules leg,
349: pay_assignment_actions pac
425: l_tax_category varchar2(10);
426: CURSOR get_details(P_ASG_ACT_ID NUMBER) is
427: SELECT nvl(target.segment13,'N')
428: FROM
429: hr_soft_coding_keyflex target,
430: per_all_assignments ASSIGN,
431: fnd_id_flex_structures fstruct,
432: pay_legislation_rules leg,
433: pay_assignment_actions pac
466:
467: CURSOR c_local_unit_id(p_assignment_id NUMBER , p_effective_date DATE ) is
468: SELECT target.segment2
469: FROM
470: hr_soft_coding_keyflex target,
471: per_all_assignments_f ASSIGN,
472: fnd_id_flex_structures fstruct,
473: pay_legislation_rules leg
474: WHERE fstruct.id_flex_num = leg.rule_mode