DBA Data[Home] [Help]

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;