APPS.PER_DB_PER_ADDITIONAL dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 907: FROM per_ass_status_type_amends

903: --
904: hr_utility.set_location('per_db_per_additional.create_applicant',4);
905: SELECT assignment_status_type_id
906: INTO l_assignment_status_type_id
907: FROM per_ass_status_type_amends
908: WHERE business_group_id + 0 = l_business_group_id
909: AND default_flag = 'Y'
910: AND per_system_status = 'ACTIVE_APL'
911: UNION

Line 919: FROM per_ass_status_type_amends ast1

915: = l_business_group_id
916: AND ast.default_flag = 'Y'
917: AND ast.per_system_status = 'ACTIVE_APL'
918: AND NOT EXISTS (SELECT null
919: FROM per_ass_status_type_amends ast1
920: WHERE ast1.business_group_id + 0 = l_business_group_id
921: AND ast1.default_flag = 'Y'
922: AND ast1.assignment_status_type_id =
923: ast.assignment_status_type_id) ;

Line 1304: FROM per_ass_status_type_amends

1300: --
1301: hr_utility.set_location('per_db_per_additional.create_employee',4);
1302: SELECT assignment_status_type_id
1303: INTO l_assignment_status_type_id
1304: FROM per_ass_status_type_amends
1305: WHERE business_group_id + 0 = l_business_group_id
1306: AND default_flag = 'Y'
1307: AND per_system_status = 'ACTIVE_ASSIGN'
1308: UNION

Line 1316: FROM per_ass_status_type_amends ast1

1312: = l_business_group_id
1313: AND ast.default_flag = 'Y'
1314: AND ast.per_system_status = 'ACTIVE_ASSIGN'
1315: AND NOT EXISTS (SELECT null
1316: FROM per_ass_status_type_amends ast1
1317: WHERE ast1.business_group_id + 0 = l_business_group_id
1318: AND ast1.default_flag = 'Y'
1319: AND ast1.assignment_status_type_id =
1320: ast.assignment_status_type_id) ;

Line 1761: FROM per_ass_status_type_amends

1757: if p_assignment_type = 'E' then -- Employee
1758: hr_utility.set_location('per_db_per_additional.create_secondary_assign',4);
1759: SELECT assignment_status_type_id
1760: INTO l_assignment_status_type_id
1761: FROM per_ass_status_type_amends
1762: WHERE business_group_id + 0 = l_business_group_id
1763: AND default_flag = 'Y'
1764: AND per_system_status = 'ACTIVE_ASSIGN'
1765: UNION

Line 1773: FROM per_ass_status_type_amends ast1

1769: = l_business_group_id
1770: AND ast.default_flag = 'Y'
1771: AND ast.per_system_status = 'ACTIVE_ASSIGN'
1772: AND NOT EXISTS (SELECT null
1773: FROM per_ass_status_type_amends ast1
1774: WHERE ast1.business_group_id + 0 = l_business_group_id
1775: AND ast1.default_flag = 'Y'
1776: AND ast1.assignment_status_type_id =
1777: ast.assignment_status_type_id) ;

Line 1783: FROM per_ass_status_type_amends

1779: else -- Applicant
1780: hr_utility.set_location('per_db_per_additional.create_secondary_assign',7);
1781: SELECT assignment_status_type_id
1782: INTO l_assignment_status_type_id
1783: FROM per_ass_status_type_amends
1784: WHERE business_group_id + 0 = l_business_group_id
1785: AND default_flag = 'Y'
1786: AND per_system_status = 'ACTIVE_APL'
1787: UNION

Line 1795: FROM per_ass_status_type_amends ast1

1791: = l_business_group_id
1792: AND ast.default_flag = 'Y'
1793: AND ast.per_system_status = 'ACTIVE_APL'
1794: AND NOT EXISTS (SELECT null
1795: FROM per_ass_status_type_amends ast1
1796: WHERE ast1.business_group_id + 0 = l_business_group_id
1797: AND ast1.default_flag = 'Y'
1798: AND ast1.assignment_status_type_id =
1799: ast.assignment_status_type_id) ;