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

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

Line 1629: from hr_soft_coding_keyflex sck

1625: and asg.organization_id = p_organization_id))
1626: AND (p_legal_entity is NULL -- LEGAL ENTITY
1627: OR
1628: exists (select 1
1629: from hr_soft_coding_keyflex sck
1630: where asg.soft_coding_keyflex_id is not null
1631: and asg.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1632: and sck.segment1 = p_legal_entity))
1633: AND (p_qual_type is NULL