APPS.PER_ES_SS_REP_DYN_TRG dependencies on PER_ALL_ASSIGNMENTS_F

Line 26: FROM per_all_assignments_f paf

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

Line 166: l_csr_find_asg_id per_all_assignments_f.assignment_id%TYPE;

162: FROM per_assignment_extra_info
163: WHERE assignment_id = p_assignment_id;
164:
165: l_ovn NUMBER;
166: l_csr_find_asg_id per_all_assignments_f.assignment_id%TYPE;
167: BEGIN
168: IF p_assignment_type = 'E' AND p_primary_flag = 'Y' THEN
169: /* Check whether there is any record in the table */
170: OPEN csr_check_asg;

Line 323: FROM per_all_assignments_f paf

319:
320: CURSOR csr_primary_flag_value(p_assignment_id NUMBER
321: ,p_effective_start_date DATE) IS
322: SELECT paf.primary_flag, paf.assignment_type
323: FROM per_all_assignments_f paf
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:

Line 331: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

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;
333:
334: BEGIN
335: OPEN csr_input_value_id('SS Epigraph Code');

Line 332: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

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;
333:
334: BEGIN
335: OPEN csr_input_value_id('SS Epigraph Code');
336: FETCH csr_input_value_id INTO l_input_value_id;

Line 445: FROM per_all_assignments_f paf

441:
442: CURSOR csr_primary_flag_value(p_assignment_id NUMBER
443: ,p_effective_start_date DATE) IS
444: SELECT paf.primary_flag, paf.assignment_type
445: FROM per_all_assignments_f paf
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:

Line 452: l_primary_flag per_all_assignments_f.primary_flag%TYPE;

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:
455: BEGIN
456: OPEN csr_input_value_id('SS Epigraph Code');

Line 453: l_assignment_type per_all_assignments_f.assignment_type%TYPE;

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:
455: BEGIN
456: OPEN csr_input_value_id('SS Epigraph Code');
457: FETCH csr_input_value_id INTO l_input_value_id;