DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on PER_ASSIGNMENTS_F

Line 1115: FROM per_assignments_f assign

1111: CURSOR emp_challan_details IS
1112: SELECT input.name name
1113: , value.screen_entry_value value
1114: , entries.element_entry_id
1115: FROM per_assignments_f assign
1116: ,pay_element_entries_f entries
1117: ,pay_element_types_f type
1118: ,pay_input_values_f input
1119: ,pay_element_entry_values_f value

Line 1153: FROM per_assignments_f assign

1149: CURSOR emp_challan_details_16aa IS
1150: SELECT input.name name
1151: , value.screen_entry_value value
1152: , entries.element_entry_id
1153: FROM per_assignments_f assign
1154: ,pay_element_entries_f entries
1155: ,pay_element_types_f type
1156: ,pay_input_values_f input
1157: ,pay_element_entry_values_f value

Line 2033: ,per_assignments_f asg

2029: SELECT MAX(pai.action_context_id) action_context_id
2030: , pai.action_information17 start_date
2031: , pai.action_information1 employee_number
2032: FROM pay_action_information pai
2033: ,per_assignments_f asg
2034: WHERE pai.action_information_category = 'IN_EOY_PERSON'
2035: AND asg.assignment_id = pai.assignment_id
2036: AND asg.business_group_id = p_business_group_id
2037: AND pai.action_information3 = p_gre_id