APPS.PAY_PYNZSOE_XMLP_PKG dependencies on PER_POSITIONS
Line 175: per_positions ppos
171: IF ass_number is not null THEN
172: select substr(ppos.name,1,30)
173: into l_position_name
174: from per_assignments_f paf, 175: per_positions ppos 176: where paf.position_id = ppos.position_id
177: --and paf.assignment_id = assignment_id
178: and paf.assignment_id = v_assignment_id
179: and date_earned between paf.effective_start_date and paf.effective_end_date;