APPS.PAY_IE_MEDICAL_ADJUST dependencies on PER_ALL_ASSIGNMENTS_F

Line 41: FROM pay_element_links_f links, per_all_assignments_f assign

37: input_val_rec1 input_val_csr%ROWTYPE;
38: --
39: CURSOR link_csr(p_element_type_id IN NUMBER) IS
40: SELECT links.element_link_id
41: FROM pay_element_links_f links, per_all_assignments_f assign
42: WHERE links.element_type_id = p_element_type_id
43: AND links.business_group_id=p_bg_id
44: AND assign.assignment_id=p_asg_id
45: AND (( links.payroll_id is not null

Line 164: l_assig_number per_all_assignments_f.assignment_number%TYPE;

160: l_ele_type_id number;
161: l_input_val_id_med number;
162: l_input_val_id_tax number;
163: l_assignment_id number := NULL;
164: l_assig_number per_all_assignments_f.assignment_number%TYPE;
165: l_report_item_type varchar(10) := NULL;
166: l_result_val varchar2(20);
167: l_result_val_l varchar2(20);
168: l_result_val_num number := 0;

Line 179: TYPE Med_Record is Record(l_m_asg_id per_all_assignments_f.assignment_id%TYPE,

175: l_under_line varchar2(130) := '----------------------------------------------------------------------------------------------------------------------------------';
176: l_asg_counter number :=0;
177: l_c_already_run number :=0; -- (0 = NOT RUN 1 = RAN )
178:
179: TYPE Med_Record is Record(l_m_asg_id per_all_assignments_f.assignment_id%TYPE,
180: l_m_Value NUMBER);
181: l_Med_Record Med_Record;
182:
183: TYPE Med_pl_table is table of Med_Record index by binary_integer;

Line 245: per_all_assignments_f paaf

241: Cursor csr_person_details (p_assg_id in number) IS
242: select distinct ppf.full_name ,
243: paaf.assignment_number
244: from per_all_people_f ppf,
245: per_all_assignments_f paaf
246: where paaf.assignment_id = p_assg_id
247: and paaf.person_id = ppf.person_id
248: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
249: