DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on HR_SOFT_CODING_KEYFLEX

Line 299: select * from hr_soft_coding_keyflex

295: where people_group_id=p_people_group_id;
296: --
297: cursor csr_scl_rec
298: (p_soft_coding_keyflex_id number) is
299: select * from hr_soft_coding_keyflex
300: where soft_coding_keyflex_id=p_soft_coding_keyflex_id;
301: --
302: cursor csr_vacancy
303: (p_vacancy_id number) is

Line 367: scl_rec hr_soft_coding_keyflex%rowtype;

363: and id_flex_num=p_id_flex_num;
364: --
365: asg_rec per_all_assignments_f%rowtype;
366: pgp_rec pay_people_groups%rowtype;
367: scl_rec hr_soft_coding_keyflex%rowtype;
368: --
369: cursor csr_vendor(p_vendor_id in number) is
370: select vendor_name
371: from po_vendors pov