APPS.PQP_GB_LGPS_PENSIONPAY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 62: ,pay_element_entry_values_f peevf

58: SELECT peevf.element_entry_id
59: ,peevf.input_value_id
60: FROM pay_element_types_f petf
61: ,pay_element_entries_f peef
62: ,pay_element_entry_values_f peevf
63: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
64: and petf.legislation_code = 'GB'
65: -- and petf.business_group_id = p_business_group_id 6652351
66: and petf.element_type_id = peef.element_type_id

Line 115: v_element_entry_id pay_element_entry_values_f.element_entry_value_id%type;

111: v_formula_id number(9);
112: Skip_formula Exception;
113: v_eff_start_date date;
114: v_eff_end_date date;
115: v_element_entry_id pay_element_entry_values_f.element_entry_value_id%type;
116: --6666135 End
117: BEGIN
118: -- setting the contexts
119: p_inputs(1).name := 'ASSIGNMENT_ID';

Line 416: --c_formula_pension_value pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type;

412:
413: c1_all_element_data c1_all_element%rowtype;
414: c2_PQP_UK_RATE_TYPE_data c2_PQP_UK_RATE_TYPE%rowtype;
415: c3_pqp_lgps_pension_pay_data c3_pqp_lgps_pension_pay%rowtype;
416: --c_formula_pension_value pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type;
417: c_formula_pension_value number;
418: v_mode varchar2(30);
419: N_start_year NUMBER;
420: n_present number;