[Home] [Help]
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
21: FROM
18:
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 ;
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;
72: l_pension_num hr_organization_information.org_information6%TYPE;
86:
87:
88: CURSOR get_details(p_asg_act_id NUMBER ) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_F asg1
91: ,per_all_assignments_F asg2
92: ,per_all_people_F per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
87:
88: CURSOR get_details(p_asg_act_id NUMBER ) IS
89: SELECT eev1.screen_entry_value screen_entry_value
90: FROM per_all_assignments_F asg1
91: ,per_all_assignments_F asg2
92: ,per_all_people_F per
93: ,pay_element_links_f el
94: ,pay_element_types_f et
95: ,pay_input_values_f iv1
129: CURSOR get_union_id(p_asg_act_id NUMBER) IS
130: SELECT pap.per_information9
131: FROM
132: pay_assignment_actions pac,
133: per_all_assignments assign,
134: per_all_people pap
135: WHERE pac.assignment_action_id = p_asg_act_id
136: AND assign.assignment_id = pac.assignment_id
137: AND assign.person_id = pap.person_id
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
148: WHERE fstruct.id_flex_num = leg.rule_mode
197: AND paa.payroll_action_id = ppa.payroll_action_id ;
198:
199: CURSOR c_person_pension_num(p_asg_act_id NUMBER , p_effective_date DATE) IS
200: SELECT PER_INFORMATION24
201: FROM per_all_assignments_f asg1
202: ,per_all_people_f per
203: ,pay_assignment_actions pac
204: WHERE per.person_id = asg1.person_id
205: AND pac.assignment_action_id = p_asg_act_id
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
350: WHERE fstruct.id_flex_num = leg.rule_mode
360: AND target.enabled_flag = 'Y';
361:
362: CURSOR get_iv_details(P_ASG_ACT_ID NUMBER ) IS
363: SELECT eev1.screen_entry_value screen_entry_value
364: FROM per_all_assignments_f asg1
365: ,pay_element_links_f el
366: ,pay_element_types_f et
367: ,pay_input_values_f iv1
368: ,pay_element_entries_f ee
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
434: WHERE fstruct.id_flex_num = leg.rule_mode
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
475: AND fstruct.id_flex_code = 'SCL'