APPS.HRSPINE dependencies on PER_QUALIFICATIONS

Line 83: rem per_qualifications and hr_soft_coding_keyflex

79: rem
80: rem Version Date Author Comment
81: rem -------+-----------+--------------+----------------------------------------
82: rem 115.39 13-MAR-2002 stlocke Changed main select cursors so as to remove
83: rem per_qualifications and hr_soft_coding_keyflex
84: rem tables as if no data in tables then cursor
85: rem will return no rows.
86: rem 115.40 14-MAR-2002 stlocke Commented in commit and exit
87: rem 115.41 25-APR-2002 stlocke Added functions used for employee increment

Line 1530: from per_qualifications pq

1526: and sck.segment1 = p_legal_entity))
1527: AND (p_qual_type is NULL
1528: OR
1529: exists (select 1
1530: from per_qualifications pq
1531: where asg.person_id = pq.person_id
1532: and pq.qualification_type_id = p_qual_type))
1533: AND (p_qual_status is NULL
1534: OR

Line 1536: from per_qualifications pq

1532: and pq.qualification_type_id = p_qual_type))
1533: AND (p_qual_status is NULL
1534: OR
1535: exists (select 1
1536: from per_qualifications pq
1537: where asg.person_id = pq.person_id
1538: and pq.qualification_type_id = p_qual_type
1539: and pq.status = p_qual_status))
1540: AND (p_org_structure_ver_id is NULL -- OGANIZATION HIERARCHY

Line 1636: from per_qualifications pq

1632: and sck.segment1 = p_legal_entity))
1633: AND (p_qual_type is NULL
1634: OR
1635: exists (select 1
1636: from per_qualifications pq
1637: where asg.person_id = pq.person_id
1638: and pq.qualification_type_id = p_qual_type))
1639: AND (p_qual_status is NULL
1640: OR

Line 1642: from per_qualifications pq

1638: and pq.qualification_type_id = p_qual_type))
1639: AND (p_qual_status is NULL
1640: OR
1641: exists (select 1
1642: from per_qualifications pq
1643: where asg.person_id = pq.person_id
1644: and pq.qualification_type_id = p_qual_type
1645: and pq.status = p_qual_status))
1646: AND (p_org_structure_ver_id is NULL -- OGANIZATION HIERARCHY