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_SE_RULES dependencies on PER_ALL_ASSIGNMENTS_F

Line 18: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

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
22: FROM

Line 23: per_all_assignments_f PAA,

19:
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 ;

Line 75: l_business_group_id per_all_assignments_f.business_group_id%TYPE ;

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;
79: l_pension_type hr_organization_information.org_information1%TYPE;

Line 95: FROM per_all_assignments_F asg1

91:
92:
93: CURSOR get_details(p_asg_act_id NUMBER ) IS
94: SELECT eev1.screen_entry_value screen_entry_value
95: FROM per_all_assignments_F asg1
96: ,per_all_assignments_F asg2
97: ,per_all_people_F per
98: ,pay_element_links_f el
99: ,pay_element_types_f et

Line 96: ,per_all_assignments_F asg2

92:
93: CURSOR get_details(p_asg_act_id NUMBER ) IS
94: SELECT eev1.screen_entry_value screen_entry_value
95: FROM per_all_assignments_F asg1
96: ,per_all_assignments_F asg2
97: ,per_all_people_F per
98: ,pay_element_links_f el
99: ,pay_element_types_f et
100: ,pay_input_values_f iv1

Line 653: FROM per_all_assignments_F asg1

649: is
650:
651: CURSOR get_details IS
652: SELECT eev1.screen_entry_value screen_entry_value
653: FROM per_all_assignments_F asg1
654: ,per_all_assignments_F asg2
655: ,per_all_people_F per
656: ,pay_element_links_f el
657: ,pay_element_types_f et

Line 654: ,per_all_assignments_F asg2

650:
651: CURSOR get_details IS
652: SELECT eev1.screen_entry_value screen_entry_value
653: FROM per_all_assignments_F asg1
654: ,per_all_assignments_F asg2
655: ,per_all_people_F per
656: ,pay_element_links_f el
657: ,pay_element_types_f et
658: ,pay_input_values_f iv1

Line 716: per_all_assignments_f ASSIGN,

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
720: AND fstruct.id_flex_code = 'SCL'