APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 51: ,pay_element_entry_values_f peevf

47: SELECT peevf.element_entry_id
48: ,peevf.input_value_id
49: FROM pay_element_types_f petf
50: ,pay_element_entries_f peef
51: ,pay_element_entry_values_f peevf
52: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
53: and petf.legislation_code = 'GB'
54: -- and petf.business_group_id = p_business_group_id 6652351
55: and petf.element_type_id = peef.element_type_id

Line 104: v_element_entry_id pay_element_entry_values_f.element_entry_value_id%type;

100: v_formula_id number(9);
101: Skip_formula Exception;
102: v_eff_start_date date;
103: v_eff_end_date date;
104: v_element_entry_id pay_element_entry_values_f.element_entry_value_id%type;
105: --6666135 End
106: BEGIN
107: -- setting the contexts
108: p_inputs(1).name := 'ASSIGNMENT_ID';

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

399:
400: c1_all_element_data c1_all_element%rowtype;
401: c2_PQP_UK_RATE_TYPE_data c2_PQP_UK_RATE_TYPE%rowtype;
402: c3_pqp_lgps_pension_pay_data c3_pqp_lgps_pension_pay%rowtype;
403: --c_formula_pension_value pay_element_entry_values_f.SCREEN_ENTRY_VALUE%type;
404: c_formula_pension_value number;
405: v_mode varchar2(30);
406: N_start_year NUMBER;
407: n_present number;