APPS.PAY_FI_RULES dependencies on PAY_ELEMENT_TYPES_F

Line 66: l_element_name PAY_ELEMENT_TYPES_F.ELEMENT_NAME%TYPE;

62: ,p_ee_id IN NUMBER
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;

Line 80: FROM pay_element_types_f pet,

76:
77:
78: CURSOR get_element_name(p_ee_id NUMBER , p_effective_date DATE ) IS
79: SELECT pet.element_name
80: FROM pay_element_types_f pet,
81: pay_element_entries_f pee
82: WHERE pee.element_entry_id = p_ee_id
83: AND pee.element_type_id = pet.element_type_id
84: AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 94: ,pay_element_types_f et

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
96: ,pay_element_entries_F ee
97: ,pay_element_entry_values_F eev1
98: ,pay_assignment_actions pac

Line 366: ,pay_element_types_f et

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
369: ,pay_element_entry_values_f eev1
370: ,pay_assignment_actions pac