DBA Data[Home] [Help]

APPS.PSB_BUDGET_REVISIONS_PVT dependencies on FND_NUMBER

Line 6984: FND_NUMBER.canonical_to_number(attribute_value) attribute_value,

6980: effective_start_date,
6981: effective_end_date,
6982: attribute_id,
6983: -- Fixed bug # 3683644
6984: FND_NUMBER.canonical_to_number(attribute_value) attribute_value,
6985: attribute_value_id
6986: from PSB_POSITION_ASSIGNMENTS
6987: where attribute_id in (PSB_WS_POS1.g_default_wklyhrs_id, PSB_WS_POS1.g_fte_id)
6988: and (( worksheet_id = g_global_budget_revision_id) or (worksheet_id is null))

Line 7000: FND_NUMBER.canonical_to_number(attribute_value) desc; -- Fixed bug # 3683644

6996: and position_id = p_position_id
6997: order by worksheet_id,
6998: effective_start_date,
6999: effective_end_date,
7000: FND_NUMBER.canonical_to_number(attribute_value) desc; -- Fixed bug # 3683644
7001:
7002: cursor c_fte is
7003: select brp.revision_type, brp.revision_value_type, brp.revision_value, brp.effective_start_date, brp.effective_end_date
7004: from PSB_BUDGET_REVISION_POSITIONS brp, PSB_BUDGET_REVISION_POS_LINES brpl