APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_PAY_ELEMENTS

Line 401: from PSB_PAY_ELEMENTS

397: l_return_status VARCHAR2(1);
398:
399: cursor c_elem is
400: select *
401: from PSB_PAY_ELEMENTS
402: where data_extract_id = p_local_data_extract_id;
403:
404: cursor c_elemname_exists (elemname VARCHAR2) is
405: select pay_element_id

Line 406: from PSB_PAY_ELEMENTS

402: where data_extract_id = p_local_data_extract_id;
403:
404: cursor c_elemname_exists (elemname VARCHAR2) is
405: select pay_element_id
406: from PSB_PAY_ELEMENTS
407: where name = elemname
408: and data_extract_id = g_global_data_extract_id;
409:
410: cursor c_elemoptions (elemid NUMBER) is

Line 501: select psb_pay_elements_s.nextval seq

497: from PSB_PAY_ELEMENT_DISTRIBUTIONS
498: where position_set_group_id = possetgrpid;
499:
500: cursor c_elem_seq is
501: select psb_pay_elements_s.nextval seq
502: from dual;
503:
504: cursor c_elemoptions_seq is
505: select psb_pay_element_options_s.nextval seq

Line 556: PSB_PAY_ELEMENTS_PVT.INSERT_ROW

552: for c_elem_seq_rec in c_elem_seq loop
553: l_pay_element_id := c_elem_seq_rec.seq;
554: end loop;
555:
556: PSB_PAY_ELEMENTS_PVT.INSERT_ROW
557: (p_api_version => 1.0,
558: p_return_status => l_return_status,
559: p_msg_count => l_msg_count,
560: p_msg_data => l_msg_data,

Line 1484: from PSB_PAY_ELEMENTS a,

1480: and position_id = positionid;
1481:
1482: cursor c_re_elem (elemid NUMBER) is
1483: select a.pay_element_id
1484: from PSB_PAY_ELEMENTS a,
1485: PSB_PAY_ELEMENTS b
1486: where a.name = b.name
1487: and a.data_extract_id = g_global_data_extract_id
1488: and b.pay_element_id = elemid;

Line 1485: PSB_PAY_ELEMENTS b

1481:
1482: cursor c_re_elem (elemid NUMBER) is
1483: select a.pay_element_id
1484: from PSB_PAY_ELEMENTS a,
1485: PSB_PAY_ELEMENTS b
1486: where a.name = b.name
1487: and a.data_extract_id = g_global_data_extract_id
1488: and b.pay_element_id = elemid;
1489:

Line 1992: from PSB_PAY_ELEMENTS a,

1988: order by position_line_id, current_stage_seq;
1989:
1990: cursor c_re_elem (elemid NUMBER) is
1991: select a.pay_element_id
1992: from PSB_PAY_ELEMENTS a,
1993: PSB_PAY_ELEMENTS b
1994: where a.name = b.name
1995: and a.data_extract_id = g_global_data_extract_id
1996: and b.pay_element_id = elemid;

Line 1993: PSB_PAY_ELEMENTS b

1989:
1990: cursor c_re_elem (elemid NUMBER) is
1991: select a.pay_element_id
1992: from PSB_PAY_ELEMENTS a,
1993: PSB_PAY_ELEMENTS b
1994: where a.name = b.name
1995: and a.data_extract_id = g_global_data_extract_id
1996: and b.pay_element_id = elemid;
1997: