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 1527: from per_qualifications pq

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

Line 1533: from per_qualifications pq

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

Line 1629: from per_qualifications pq

1625: and sck.segment1 = p_legal_entity))
1626: AND (p_qual_type is NULL
1627: OR
1628: exists (select 1
1629: from per_qualifications pq
1630: where asg.person_id = pq.person_id
1631: and pq.qualification_type_id = p_qual_type))
1632: AND (p_qual_status is NULL
1633: OR

Line 1635: from per_qualifications pq

1631: and pq.qualification_type_id = p_qual_type))
1632: AND (p_qual_status is NULL
1633: OR
1634: exists (select 1
1635: from per_qualifications pq
1636: where asg.person_id = pq.person_id
1637: and pq.qualification_type_id = p_qual_type
1638: and pq.status = p_qual_status))
1639: AND (p_org_structure_ver_id is NULL -- OGANIZATION HIERARCHY