APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on PER_BUSINESS_GROUPS

Line 338: from per_business_groups

334: ORDER BY 1,3,4 desc;
335:
336: Cursor C_flex_num is
337: select position_structure
338: from per_business_groups
339: where business_group_id = p_business_group_id;
340:
341: Cursor C_pos_segs is
342: select application_column_name

Line 1088: from per_business_groups

1084: AND ppb.input_value_id = piv.input_value_id;
1085: --
1086: /*Cursor C_flex_num is
1087: select grade_structure
1088: from per_business_groups
1089: where business_group_id = p_business_group_id; */
1090: --
1091: Cursor C_session is
1092: SELECT effective_date

Line 3494: from per_business_groups

3490: ORDER BY attribute_id;
3491:
3492: Cursor C_flex_num is
3493: Select job_structure
3494: from per_business_groups
3495: where business_group_id = p_business_group_id;
3496:
3497: Cursor C_Organizations is
3498: Select organization_id, name

Line 4633: from per_business_groups

4629: where lookup_type_meaning = l_definition_table;
4630:
4631: Cursor C_job_structure is
4632: Select job_structure
4633: from per_business_groups
4634: where business_group_id = p_business_group_id;
4635:
4636: Cursor C_Pos_Org is
4637: Select name