[Home] [Help]
689: effective_start_date,
690: effective_end_date,
691: attribute_id,
692: -- Fixed bug # 3683644
693: FND_NUMBER.canonical_to_number(attribute_value) attribute_value,
694: attribute_value_id
695: from PSB_POSITION_ASSIGNMENTS
696: where attribute_id in (PSB_WS_POS1.g_fte_id, PSB_WS_POS1.g_default_wklyhrs_id)
697: and (worksheet_id is null or worksheet_id = l_assign_worksheet_id)
705: and position_id = l_position_id
706: order by worksheet_id,
707: effective_start_date,
708: effective_end_date,
709: FND_NUMBER.canonical_to_number(attribute_value) desc; -- Fixed bug # 3683644
710:
711: BEGIN
712:
713: -- Standard call to check for call compatibility
1432: need to find attribute values based on value table flag for attribute.
1433: */
1434: CURSOR l_default_weekly_hrs_csr IS
1435: -- Fixed bug # 3683644
1436: SELECT MAX(FND_NUMBER.canonical_TO_NUMBER(attribute_value)) attribute_value
1437: FROM psb_position_assignments
1438: WHERE attribute_id = PSB_WS_POS1.g_default_wklyhrs_id
1439: AND (worksheet_id IS NULL OR worksheet_id = g_weekly_hours_worksheet_id)
1440: AND assignment_type = 'ATTRIBUTE'
1441: AND position_id = p_position_id ;
1442: --
1443: CURSOR l_default_weekly_hrs_vt_csr IS
1444: -- Fixed bug # 3683644
1445: SELECT MAX(FND_NUMBER.canonical_TO_NUMBER(vals.attribute_value)) attribute_value
1446: FROM psb_position_assignments asgn ,
1447: psb_attribute_values vals
1448: WHERE asgn.attribute_id = PSB_WS_POS1.g_default_wklyhrs_id
1449: AND ( asgn.worksheet_id IS NULL
5369: l_attribute_value NUMBER;
5370:
5371: cursor c_AttrVal is
5372: -- Fixed bug # 3683644
5373: select FND_NUMBER.canonical_to_number(attribute_value) attribute_value
5374: from PSB_ATTRIBUTE_VALUES
5375: where attribute_value_id = p_attribute_value_id;
5376:
5377: BEGIN