DBA Data[Home] [Help]

APPS.GHR_FORMULA_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 450: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;

446: RETURN VARCHAR2 Is
447:
448: l_proc_name varchar2(100);
449: v_eligible varchar2(1);
450: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
451: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;
452: v_per_system_status per_assignment_status_types.per_system_status%type;
453: v_annuitant_indicator varchar2(50);
454: v_asg_ei_data per_assignment_extra_info%rowtype;

Line 451: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;

447:
448: l_proc_name varchar2(100);
449: v_eligible varchar2(1);
450: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
451: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;
452: v_per_system_status per_assignment_status_types.per_system_status%type;
453: v_annuitant_indicator varchar2(50);
454: v_asg_ei_data per_assignment_extra_info%rowtype;
455:

Line 504: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;

500: RETURN VARCHAR2 is
501:
502: l_proc_name varchar2(100);
503: v_eligible varchar2(1);
504: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;
505: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
506: Begin
507: l_proc_name := g_package || '.check_if_emp_csrs';
508: hr_utility.set_location('Entering '||l_proc_name,10);

Line 505: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;

501:
502: l_proc_name varchar2(100);
503: v_eligible varchar2(1);
504: v_effective_start_date pay_element_entry_values_f.effective_start_date%type;
505: v_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
506: Begin
507: l_proc_name := g_package || '.check_if_emp_csrs';
508: hr_utility.set_location('Entering '||l_proc_name,10);
509: hr_utility.trace('p_asg_id = ' ||p_asg_id );