APPS.PSB_POSITION_CONTROL_PVT dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 529: from PSB_PAY_ELEMENT_OPTIONS

525: and data_extract_id = p_target_data_extract_id;
526:
527: cursor c_elemoptions (elemid NUMBER) is
528: select *
529: from PSB_PAY_ELEMENT_OPTIONS
530: where pay_element_id = elemid;
531:
532: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
533: select pay_element_option_id

Line 534: from PSB_PAY_ELEMENT_OPTIONS

530: where pay_element_id = elemid;
531:
532: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
533: select pay_element_option_id
534: from PSB_PAY_ELEMENT_OPTIONS
535: where name = optname
536: and pay_element_id = elemid;
537:
538: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is

Line 614: select psb_pay_element_options_s.nextval seq

610: select psb_pay_elements_s.nextval seq
611: from dual;
612:
613: cursor c_elemoptions_seq is
614: select psb_pay_element_options_s.nextval seq
615: from dual;
616:
617: cursor c_posset_seq is
618: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq

Line 738: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

734: for c_elemoptions_seq_rec in c_elemoptions_seq loop
735: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
736: end loop;
737:
738: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
739: (p_api_version => 1.0,
740: p_return_status => l_return_status,
741: p_msg_count => l_msg_count,
742: p_msg_data => l_msg_data,

Line 1445: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

1441: for c_elemoptions_seq_rec in c_elemoptions_seq loop
1442: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
1443: end loop;
1444:
1445: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1446: (p_api_version => 1.0,
1447: p_return_status => l_return_status,
1448: p_msg_count => l_msg_count,
1449: p_msg_data => l_msg_data,

Line 1587: from PSB_PAY_ELEMENT_OPTIONS

1583: and data_extract_id = p_target_data_extract_id;
1584:
1585: cursor c_elemoptions (elemid NUMBER) is
1586: select *
1587: from PSB_PAY_ELEMENT_OPTIONS
1588: where pay_element_id = elemid;
1589:
1590: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
1591: select pay_element_option_id

Line 1592: from PSB_PAY_ELEMENT_OPTIONS

1588: where pay_element_id = elemid;
1589:
1590: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
1591: select pay_element_option_id
1592: from PSB_PAY_ELEMENT_OPTIONS
1593: where name = optname
1594: and pay_element_id = elemid;
1595:
1596: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is

Line 1625: select psb_pay_element_options_s.nextval seq

1621: select psb_pay_elements_s.nextval seq
1622: from dual;
1623:
1624: cursor c_elemoptions_seq is
1625: select psb_pay_element_options_s.nextval seq
1626: from dual;
1627:
1628: BEGIN
1629:

Line 1709: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

1705: for c_elemoptions_seq_rec in c_elemoptions_seq loop
1706: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
1707: end loop;
1708:
1709: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1710: (p_api_version => 1.0,
1711: p_return_status => l_return_status,
1712: p_msg_count => l_msg_count,
1713: p_msg_data => l_msg_data,

Line 1872: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

1868: for c_elemoptions_seq_rec in c_elemoptions_seq loop
1869: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
1870: end loop;
1871:
1872: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1873: (p_api_version => 1.0,
1874: p_return_status => l_return_status,
1875: p_msg_count => l_msg_count,
1876: p_msg_data => l_msg_data,

Line 3175: from PSB_PAY_ELEMENT_OPTIONS a,

3171: and b.pay_element_id = elemid;
3172:
3173: cursor c_re_elemopt (elemid NUMBER, elemoptid NUMBER) is
3174: select a.pay_element_option_id
3175: from PSB_PAY_ELEMENT_OPTIONS a,
3176: PSB_PAY_ELEMENT_OPTIONS b
3177: where a.name = b.name
3178: and a.pay_element_id = elemid
3179: and b.pay_element_option_id = elemoptid

Line 3176: PSB_PAY_ELEMENT_OPTIONS b

3172:
3173: cursor c_re_elemopt (elemid NUMBER, elemoptid NUMBER) is
3174: select a.pay_element_option_id
3175: from PSB_PAY_ELEMENT_OPTIONS a,
3176: PSB_PAY_ELEMENT_OPTIONS b
3177: where a.name = b.name
3178: and a.pay_element_id = elemid
3179: and b.pay_element_option_id = elemoptid
3180: and nvl(a.sequence_number, -1) = nvl(b.sequence_number, -1);