APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 6166: from pqp_assignment_attributes_f

6162: ,tp_fast_track
6163: ,tp_elected_pension
6164: -- added the new column for the new safeguarded logic based on safeguarded rate type
6165: ,tp_safeguarded_rate_type
6166: from pqp_assignment_attributes_f
6167: where assignment_id = c_assignment_id
6168: and c_effective_date between effective_start_date
6169: and effective_end_date
6170: order by effective_start_date;

Line 6227: l_paa_attribute_id pqp_assignment_attributes_f.assignment_attribute_id%type := null;

6223: --
6224: l_proc_name varchar2(60) := g_proc_name || 'process_element';
6225: l_ele_rate csr_ele_rate_id%rowtype;
6226: l_paa_rate csr_paa_rate_id%rowtype;
6227: l_paa_attribute_id pqp_assignment_attributes_f.assignment_attribute_id%type := null;
6228: l_value number := 0;
6229: --
6230: begin
6231: --

Line 14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;

14006:
14007: l_other_allowance VARCHAR2(5) := '00000';
14008: l_temp_date DATE;
14009: l_temp_date_primary DATE;
14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;

Line 14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;

14007: l_other_allowance VARCHAR2(5) := '00000';
14008: l_temp_date DATE;
14009: l_temp_date_primary DATE;
14010: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14011: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
14012: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
14013: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
14014: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
14015: l_rowcount NUMBER:=0;