APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PQP_ASSIGNMENT_ATTRIBUTES_F

Line 6138: from pqp_assignment_attributes_f

6134: ,tp_fast_track
6135: ,tp_elected_pension
6136: -- added the new column for the new safeguarded logic based on safeguarded rate type
6137: ,tp_safeguarded_rate_type
6138: from pqp_assignment_attributes_f
6139: where assignment_id = c_assignment_id
6140: and c_effective_date between effective_start_date
6141: and effective_end_date
6142: order by effective_start_date;

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

6195: --
6196: l_proc_name varchar2(60) := g_proc_name || 'process_element';
6197: l_ele_rate csr_ele_rate_id%rowtype;
6198: l_paa_rate csr_paa_rate_id%rowtype;
6199: l_paa_attribute_id pqp_assignment_attributes_f.assignment_attribute_id%type := null;
6200: l_value number := 0;
6201: --
6202: begin
6203: --

Line 13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;

13807:
13808: l_other_allowance VARCHAR2(5) := '00000';
13809: l_temp_date DATE;
13810: l_temp_date_primary DATE;
13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;

Line 13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;

13808: l_other_allowance VARCHAR2(5) := '00000';
13809: l_temp_date DATE;
13810: l_temp_date_primary DATE;
13811: l_temp_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13812: l_new_sfgrade pqp_assignment_attributes_f.tp_safeguarded_grade%TYPE;
13813: l_london_allowance ben_ext_rslt_dtl.val_21%TYPE;
13814: l_sp_allowance ben_ext_rslt_dtl.val_22%TYPE;
13815: l_contract_indicator ben_ext_rslt_dtl.val_23%TYPE;
13816: l_rowcount NUMBER:=0;