APPS.PQH_RCT_BUS dependencies on PER_POSITION_STRUCTURES

Line 1063: from per_position_structures a

1059: l_dummy varchar2(1);
1060: --
1061: cursor c1 is
1062: select null
1063: from per_position_structures a
1064: where a.position_structure_id = p_position_structure_id;
1065: --
1066: Begin
1067: --

Line 1080: -- check if position_structure_id value exists in per_position_structures table

1076: <> nvl(pqh_rct_shd.g_old_rec.position_structure_id,hr_api.g_number)
1077: or not l_api_updating) and
1078: p_position_structure_id is not null then
1079: --
1080: -- check if position_structure_id value exists in per_position_structures table
1081: --
1082: open c1;
1083: --
1084: fetch c1 into l_dummy;

Line 1089: -- raise error as FK does not relate to PK in per_position_structures

1085: if c1%notfound then
1086: --
1087: close c1;
1088: --
1089: -- raise error as FK does not relate to PK in per_position_structures
1090: -- table.
1091: --
1092: pqh_rct_shd.constraint_error('PQH_ROUTING_CATEGORIES_FK3');
1093: --

Line 1292: sql_stmt := sql_stmt ||'a.range_name, a.attribute_id, a.from_char, a.to_char, a.from_number, a.to_number, a.from_date, a.to_date from pqh_attribute_ranges a,pqh_routing_categories b, pqh_routing_lists RLT, per_position_structures PPS ';

1288: ||''''||'PQH_SUPERVISORY_HIERARCHY'||''''||','
1289: ||''''||'SUPERVISORY_HIERARCHY'||''''||'),';
1290: End if;
1291:
1292: sql_stmt := sql_stmt ||'a.range_name, a.attribute_id, a.from_char, a.to_char, a.from_number, a.to_number, a.from_date, a.to_date from pqh_attribute_ranges a,pqh_routing_categories b, pqh_routing_lists RLT, per_position_structures PPS ';
1293:
1294: sql_stmt := sql_stmt ||' Where b.transaction_category_id = :p_transaction_category_id and b.enable_flag = :p_enable_flag '
1295: ||' and nvl(b.default_flag,:null_val) <> :p_default_flag and nvl(b.delete_flag,:null_val2) <> :p_delete_flag and b.routing_category_id = a.routing_category_id(+) ';
1296: