APPS.PER_ES_SS_REP_DYN_TRG dependencies on PAY_INPUT_VALUES_F

Line 316: FROM pay_input_values_f piv

312: AND aei_information3 IN ('EP','EC');
313:
314: CURSOR csr_input_value_id(p_name VARCHAR2) IS
315: SELECT input_value_id
316: FROM pay_input_values_f piv
317: WHERE piv.name = p_name
318: AND legislation_code = 'ES';
319:
320: CURSOR csr_primary_flag_value(p_assignment_id NUMBER

Line 330: l_input_value_id pay_input_values_f.input_value_id%TYPE;

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;
333:
334: BEGIN

Line 438: FROM pay_input_values_f piv

434: AND aei_information5 <> 'Y';
435:
436: CURSOR csr_input_value_id(p_name VARCHAR2) IS
437: SELECT input_value_id
438: FROM pay_input_values_f piv
439: WHERE piv.name = p_name
440: AND legislation_code = 'ES';
441:
442: CURSOR csr_primary_flag_value(p_assignment_id NUMBER

Line 451: l_input_value_id pay_input_values_f.input_value_id%type;

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:
455: BEGIN