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_POSITION_CONTROL_PVT dependencies on PSB_PAY_ELEMENT_RATES

Line 540: from PSB_PAY_ELEMENT_RATES

536: and pay_element_id = elemid;
537:
538: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is
539: select *
540: from PSB_PAY_ELEMENT_RATES
541: where worksheet_id is null
542: and pay_element_option_id = elemoptionid
543: and pay_element_id = elemid;
544:

Line 547: from PSB_PAY_ELEMENT_RATES

543: and pay_element_id = elemid;
544:
545: cursor c_elemrates_nooptions (elemid NUMBER) is
546: select *
547: from PSB_PAY_ELEMENT_RATES
548: where worksheet_id is null
549: and pay_element_id = elemid;
550:
551: cursor c_possetgrp (elemid NUMBER) is

Line 759: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

755: raise FND_API.G_EXC_ERROR;
756: end if;
757:
758: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
759: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
760: (p_api_version => 1.0,
761: p_return_status => l_return_status,
762: p_msg_count => l_msg_count,
763: p_msg_data => l_msg_data,

Line 792: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

788: begin
789:
790: for c_elemrates_rec in c_elemrates_nooptions (c_elem_rec.pay_element_id) loop
791:
792: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
793: (p_api_version => 1.0,
794: p_return_status => l_return_status,
795: p_msg_count => l_msg_count,
796: p_msg_data => l_msg_data,

Line 1466: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1462: raise FND_API.G_EXC_ERROR;
1463: end if;
1464:
1465: for c_elemrates_rec in c_elemrates(c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
1466: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1467: (p_api_version => 1.0,
1468: p_return_status => l_return_status,
1469: p_msg_count => l_msg_count,
1470: p_msg_data => l_msg_data,

Line 1502: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1498: begin
1499:
1500: for c_elemrates_rec in c_elemrates_nooptions (c_elem_rec.pay_element_id) loop
1501:
1502: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1503: (p_api_version => 1.0,
1504: p_return_status => l_return_status,
1505: p_msg_count => l_msg_count,
1506: p_msg_data => l_msg_data,

Line 1598: from PSB_PAY_ELEMENT_RATES a

1594: and pay_element_id = elemid;
1595:
1596: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is
1597: select *
1598: from PSB_PAY_ELEMENT_RATES a
1599: where a.pay_element_id = elemid
1600: and a.pay_element_option_id = elemoptionid
1601: and ((a.worksheet_id = p_worksheet_id)
1602: or (a.worksheet_id is null

Line 1604: (select 1 from PSB_PAY_ELEMENT_RATES b

1600: and a.pay_element_option_id = elemoptionid
1601: and ((a.worksheet_id = p_worksheet_id)
1602: or (a.worksheet_id is null
1603: and not exists
1604: (select 1 from PSB_PAY_ELEMENT_RATES b
1605: where b.pay_element_id = a.pay_element_id
1606: and b.pay_element_option_id = a.pay_element_option_id
1607: and b.worksheet_id = p_worksheet_id)));
1608:

Line 1611: from PSB_PAY_ELEMENT_RATES a

1607: and b.worksheet_id = p_worksheet_id)));
1608:
1609: cursor c_elemrates_nooptions (elemid NUMBER) is
1610: select *
1611: from PSB_PAY_ELEMENT_RATES a
1612: where a.pay_element_id = elemid
1613: and ((a.worksheet_id = p_worksheet_id)
1614: or (a.worksheet_id is null
1615: and not exists

Line 1616: (select 1 from PSB_PAY_ELEMENT_RATES b

1612: where a.pay_element_id = elemid
1613: and ((a.worksheet_id = p_worksheet_id)
1614: or (a.worksheet_id is null
1615: and not exists
1616: (select 1 from PSB_PAY_ELEMENT_RATES b
1617: where b.pay_element_id = a.pay_element_id
1618: and b.worksheet_id = p_worksheet_id)));
1619:
1620: cursor c_elem_seq is

Line 1730: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1726: raise FND_API.G_EXC_ERROR;
1727: end if;
1728:
1729: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
1730: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1731: (p_api_version => 1.0,
1732: p_return_status => l_return_status,
1733: p_msg_count => l_msg_count,
1734: p_msg_data => l_msg_data,

Line 1763: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1759: begin
1760:
1761: for c_elemrates_rec in c_elemrates_nooptions (c_elem_rec.pay_element_id) loop
1762:
1763: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1764: (p_api_version => 1.0,
1765: p_return_status => l_return_status,
1766: p_msg_count => l_msg_count,
1767: p_msg_data => l_msg_data,

Line 1894: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1890: end if;
1891:
1892: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
1893:
1894: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1895: (p_api_version => 1.0,
1896: p_return_status => l_return_status,
1897: p_msg_count => l_msg_count,
1898: p_msg_data => l_msg_data,

Line 1925: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1921: begin /* Element Option exists; only need to refresh the rates */
1922:
1923: for c_elemrates_rec in c_elemrates (c_elem_rec.pay_element_id, c_elemoptions_rec.pay_element_option_id) loop
1924:
1925: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1926: (p_api_version => 1.0,
1927: p_return_status => l_return_status,
1928: p_msg_count => l_msg_count,
1929: p_msg_data => l_msg_data,

Line 1961: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates

1957: begin
1958:
1959: for c_elemrates_rec in c_elemrates_nooptions (c_elem_rec.pay_element_id) loop
1960:
1961: PSB_PAY_ELEMENT_RATES_PVT.Modify_Element_Rates
1962: (p_api_version => 1.0,
1963: p_return_status => l_return_status,
1964: p_msg_count => l_msg_count,
1965: p_msg_data => l_msg_data,