APPS.BEN_ELEMENT_ENTRY dependencies on PER_ALL_ASSIGNMENTS_F

Line 1164: FROM per_all_assignments_f asg, per_assignment_status_types ast

1160: )
1161: IS
1162: SELECT asg.assignment_id, asg.payroll_id, asg.organization_id,
1163: asg.effective_start_date, asg.effective_end_date
1164: FROM per_all_assignments_f asg, per_assignment_status_types ast
1165: WHERE asg.person_id = c_person_id
1166: AND asg.assignment_type <> 'C'
1167: AND asg.primary_flag = 'Y'
1168: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 2148: from per_all_assignments_f asg

2144: asg.organization_id,
2145: asg.location_id,
2146: asg.pay_basis_id,
2147: asg.employment_category
2148: from per_all_assignments_f asg
2149: where asg.assignment_id = c_asg_id
2150: and c_eff_date
2151: between asg.effective_start_date and asg.effective_end_date;
2152: --

Line 2198: from per_all_assignments_f asg,

2194: ,c_eff_date date
2195: )
2196: is
2197: select el.element_link_id
2198: from per_all_assignments_f asg,
2199: pay_element_links_f el
2200: where asg.assignment_id = c_asg_id
2201: and el.business_group_id = asg.business_group_id
2202: and el.element_type_id = c_elt_id

Line 3279: from per_all_assignments_f asg,

3275: cp_effective_date date,
3276: cp_orig_effective_date date
3277: ) is
3278: select pay.period_type
3279: from per_all_assignments_f asg,
3280: pay_payrolls_f pay,
3281: per_all_assignments_f asg2,
3282: pay_payrolls_f pay2
3283: where asg.person_id = cp_person_id

Line 3281: per_all_assignments_f asg2,

3277: ) is
3278: select pay.period_type
3279: from per_all_assignments_f asg,
3280: pay_payrolls_f pay,
3281: per_all_assignments_f asg2,
3282: pay_payrolls_f pay2
3283: where asg.person_id = cp_person_id
3284: and asg.assignment_type <> 'C'
3285: and asg.business_group_id = cp_business_group_id

Line 6682: from per_all_assignments_f asg,

6678: pet.element_name,
6679: pet.multiple_entries_allowed_flag,
6680: pel.element_type_id,
6681: pev.input_value_id
6682: from per_all_assignments_f asg,
6683: pay_element_links_f pel,
6684: pay_element_types_f pet,
6685: pay_element_entries_f pee,
6686: pay_element_entry_values_f pev

Line 8124: from per_all_assignments_f asg,

8120: pee.original_entry_id,
8121: pee.entry_type,
8122: pee.element_link_id,
8123: pev.screen_entry_value
8124: from per_all_assignments_f asg,
8125: pay_element_links_f pel,
8126: pay_element_entries_f pee,
8127: pay_element_entry_values_f pev
8128: where asg.person_id = p_person_id