eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 17: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;

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

Line 22: per_all_assignments_f PAA ,

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 ;

Line 68: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;

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;

Line 90: FROM per_all_assignments_F asg1

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

Line 91: ,per_all_assignments_F asg2

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

Line 201: FROM per_all_assignments_f asg1

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

Line 364: FROM per_all_assignments_f asg1

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

Line 471: per_all_assignments_f ASSIGN,

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'