eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSB_WS_POS2 dependencies on PSB_POSITION_ASSIGNMENTS

Line 594: from PSB_POSITION_ASSIGNMENTS

590: element_value_type,
591: element_value,
592: effective_start_date,
593: effective_end_date
594: from PSB_POSITION_ASSIGNMENTS
595: where (worksheet_id is null or worksheet_id = l_assign_worksheet_id)
596: and currency_code = l_func_currency
597: and assignment_type = 'ELEMENT'
598: and (((effective_start_date <= l_end_date)

Line 618: from PSB_POSITION_ASSIGNMENTS a

614: element_value_type,
615: element_value,
616: effective_start_date,
617: effective_end_date
618: from PSB_POSITION_ASSIGNMENTS a
619: where currency_code = l_func_currency
620: and assignment_type = 'ELEMENT'
621: and position_id = l_position_id
622: and ((worksheet_id = l_assign_worksheet_id)

Line 626: from psb_position_assignments c

622: and ((worksheet_id = l_assign_worksheet_id)
623: or (worksheet_id IS NULL
624: and not exists
625: (select 1
626: from psb_position_assignments c
627: where (
628: ( nvl(c.effective_start_date, l_end_date + 1)
629: between nvl(a.effective_start_date, l_end_date)
630: and nvl(a.effective_end_date, nvl(l_end_date, c.effective_start_date)))

Line 661: from PSB_POSITION_ASSIGNMENTS c

657: where (a.worksheet_id is null or a.worksheet_id = l_global_worksheet_id)
658: and a.currency_code = l_func_currency
659: and exists
660: (select 1
661: from PSB_POSITION_ASSIGNMENTS c
662: where nvl(c.pay_element_option_id, FND_API.G_MISS_NUM) = nvl(a.pay_element_option_id, FND_API.G_MISS_NUM)
663: and (c.worksheet_id is null or c.worksheet_id = l_assign_worksheet_id)
664: and c.currency_code = l_func_currency
665: and (((c.effective_start_date <= l_end_date)

Line 695: from PSB_POSITION_ASSIGNMENTS

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)
698: and assignment_type = 'ATTRIBUTE'
699: and (((effective_start_date <= l_end_date)

Line 1437: FROM psb_position_assignments

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 ;

Line 1446: FROM psb_position_assignments asgn ,

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
1450: OR