APPS.PAY_GB_ENROLL_PEN_REPORTING dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 36: cursor cur_input_id_value(p_input_id cur_input_id%rowtype,p_elem_entry_id pay_element_entry_values_f.element_entry_id%type,p_end_date date) is

32: FROM
33: (SELECT input_value_id, name from pay_input_values_f);
34:
35:
36: cursor cur_input_id_value(p_input_id cur_input_id%rowtype,p_elem_entry_id pay_element_entry_values_f.element_entry_id%type,p_end_date date) is
37: select
38: MAX(DECODE ( input_value_id , p_input_id.qualifying_scheme_name, SCREEN_ENTRY_VALUE )) qualifying_scheme_name,
39: MAX(DECODE ( input_value_id , p_input_id.auto_enrollment_date, SCREEN_ENTRY_VALUE )) auto_enrollment_date,
40: MAX(DECODE ( input_value_id , p_input_id.pension_classification, SCREEN_ENTRY_VALUE )) pension_classification,

Line 51: (SELECT input_value_id,SCREEN_ENTRY_VALUE from pay_element_entry_values_f

47: MAX(DECODE ( input_value_id , p_input_id.opt_in_Date, SCREEN_ENTRY_VALUE ))opt_in_date,
48: MAX(DECODE ( input_value_id , p_input_id.post_period_end_date, SCREEN_ENTRY_VALUE ))post_period_end_date
49:
50: FROM
51: (SELECT input_value_id,SCREEN_ENTRY_VALUE from pay_element_entry_values_f
52: where element_entry_id = p_elem_entry_id
53: and p_end_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
54: );
55:

Line 87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;

83:
84: l_cur_element_entry_assignment cur_element_entry_assignment%ROWTYPE;
85: l_full_name per_all_people_f.full_name%TYPE;
86: l_age number;
87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;
91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;

Line 88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;

84: l_cur_element_entry_assignment cur_element_entry_assignment%ROWTYPE;
85: l_full_name per_all_people_f.full_name%TYPE;
86: l_age number;
87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;
91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;
92: l_payroll_name cur_payroll_name%rowtype;

Line 89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;

85: l_full_name per_all_people_f.full_name%TYPE;
86: l_age number;
87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;
91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;
92: l_payroll_name cur_payroll_name%rowtype;
93: l_period/*p_name*/ cur_get_input_time%rowtype;

Line 90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;

86: l_age number;
87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;
91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;
92: l_payroll_name cur_payroll_name%rowtype;
93: l_period/*p_name*/ cur_get_input_time%rowtype;
94: l_input_id_value cur_input_id_value%rowtype;

Line 91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;

87: l_auto_enrol_date/*auto_en_date*/ pay_element_entry_values_f.screen_entry_value%TYPE;
88: l_total_earning_prp pay_element_entry_values_f.screen_entry_value%TYPE;
89: l_opt_out_date pay_element_entry_values_f.screen_entry_value%TYPE;
90: l_emp_classification pay_element_entry_values_f.screen_entry_value%TYPE;
91: l_pension_scheme_name pay_element_entry_values_f.screen_entry_value%TYPE;
92: l_payroll_name cur_payroll_name%rowtype;
93: l_period/*p_name*/ cur_get_input_time%rowtype;
94: l_input_id_value cur_input_id_value%rowtype;
95: l_input_id cur_input_id%rowtype;