APPS.HRSPINE dependencies on HR_SOFT_CODING_KEYFLEX

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 1520: from hr_soft_coding_keyflex sck

1516: and asg.organization_id = p_organization_id))
1517: AND (p_legal_entity is NULL -- LEGAL ENTITY
1518: OR
1519: exists (select 1
1520: from hr_soft_coding_keyflex sck
1521: where asg.soft_coding_keyflex_id is not null
1522: and asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1523: and sck.segment1 = p_legal_entity))
1524: AND (p_qual_type is NULL

Line 1622: from hr_soft_coding_keyflex sck

1618: and asg.organization_id = p_organization_id))
1619: AND (p_legal_entity is NULL -- LEGAL ENTITY
1620: OR
1621: exists (select 1
1622: from hr_soft_coding_keyflex sck
1623: where asg.soft_coding_keyflex_id is not null
1624: and asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1625: and sck.segment1 = p_legal_entity))
1626: AND (p_qual_type is NULL