APPS.PER_ES_SS_REP_DYN_TRG dependencies on PAY_ELEMENT_ENTRIES_F

Line 10: FROM pay_element_entries_f

6: -----------------------------------------------------
7: FUNCTION get_assignment_id(p_element_entry_id NUMBER) RETURN NUMBER IS
8: CURSOR csr_find_asg_id IS
9: SELECT assignment_id
10: FROM pay_element_entries_f
11: WHERE element_entry_id = p_element_entry_id;
12:
13: l_assignment_id NUMBER;
14: BEGIN

Line 27: ,pay_element_entries_f peef

23: FUNCTION get_business_group_id(p_element_entry_id NUMBER) RETURN NUMBER IS
24: CURSOR csr_find_business_grp_id IS
25: SELECT business_group_id
26: FROM per_all_assignments_f paf
27: ,pay_element_entries_f peef
28: WHERE peef.element_entry_id = p_element_entry_id
29: AND peef.assignment_id = paf.assignment_id;
30:
31: l_business_group_id NUMBER;

Line 328: l_assg_id pay_element_entries_f.assignment_id%TYPE;

324: WHERE paf.assignment_id = p_assignment_id
325: AND p_effective_start_date BETWEEN paf.effective_start_date
326: AND paf.effective_end_date;
327:
328: l_assg_id pay_element_entries_f.assignment_id%TYPE;
329: l_assg_info_id per_assignment_extra_info.assignment_extra_info_id%TYPE;
330: l_input_value_id pay_input_values_f.input_value_id%TYPE;
331: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
332: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

Line 450: l_assignment_id pay_element_entries_f.assignment_id%type;

446: WHERE paf.assignment_id = p_assignment_id
447: AND p_effective_start_date BETWEEN paf.effective_start_date
448: AND paf.effective_end_date;
449:
450: l_assignment_id pay_element_entries_f.assignment_id%type;
451: l_input_value_id pay_input_values_f.input_value_id%type;
452: l_primary_flag per_all_assignments_f.primary_flag%TYPE;
453: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
454: