APPS.PQP_US_SRS_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 155: pay_element_types_f pet

151: ) Is
152: SELECT aei_information5,
153: aei_information6
154: FROM per_assignment_extra_info paei,
155: pay_element_types_f pet
156: WHERE assignment_id = c_assignment_id
157: AND information_type = 'PQP_US_SRS_PLAN_ASG_INFO'
158: AND aei_information4 = pet.element_name
159: AND element_type_id = c_element_type_id

Line 172: from pay_element_types_f pet

168: Cursor csr_ele (c_element_name in varchar2
169: ,c_effective_date in date
170: ,c_business_group_id in number) Is
171: Select pet.element_type_id
172: from pay_element_types_f pet
173: Where pet.element_name = c_element_name
174: and pet.business_group_id = c_business_group_id
175: and c_effective_date between pet.effective_start_date
176: and pet.effective_end_date;

Line 192: l_ele_name pay_element_types_f.element_name%TYPE;

188: l_aei_information5 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION5%TYPE;
189: l_aei_information6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE;
190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
192: l_ele_name pay_element_types_f.element_name%TYPE;
193: l_base_ele_id pay_element_types_f.element_type_id%TYPE;
194: l_buyback_ele_id pay_element_types_f.element_type_id%TYPE;
195: l_return_value VARCHAR2(2) := 'N';
196: BEGIN

Line 193: l_base_ele_id pay_element_types_f.element_type_id%TYPE;

189: l_aei_information6 PER_ASSIGNMENT_EXTRA_INFO.AEI_INFORMATION6%TYPE;
190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
192: l_ele_name pay_element_types_f.element_name%TYPE;
193: l_base_ele_id pay_element_types_f.element_type_id%TYPE;
194: l_buyback_ele_id pay_element_types_f.element_type_id%TYPE;
195: l_return_value VARCHAR2(2) := 'N';
196: BEGIN
197: l_effective_date := TRUNC(pqp_us_srs_functions.get_date_paid

Line 194: l_buyback_ele_id pay_element_types_f.element_type_id%TYPE;

190: l_effective_date DATE;
191: l_srs_enrolled VARCHAR2(1) := 'N';
192: l_ele_name pay_element_types_f.element_name%TYPE;
193: l_base_ele_id pay_element_types_f.element_type_id%TYPE;
194: l_buyback_ele_id pay_element_types_f.element_type_id%TYPE;
195: l_return_value VARCHAR2(2) := 'N';
196: BEGIN
197: l_effective_date := TRUNC(pqp_us_srs_functions.get_date_paid
198: (p_payroll_action_id)