APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_PAY_ELEMENT_OPTIONS

Line 412: from PSB_PAY_ELEMENT_OPTIONS

408: and data_extract_id = g_global_data_extract_id;
409:
410: cursor c_elemoptions (elemid NUMBER) is
411: select *
412: from PSB_PAY_ELEMENT_OPTIONS
413: where pay_element_id = elemid;
414:
415: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
416: select pay_element_option_id

Line 417: from PSB_PAY_ELEMENT_OPTIONS

413: where pay_element_id = elemid;
414:
415: cursor c_elemoptions_exists (elemid NUMBER, optname VARCHAR2) is
416: select pay_element_option_id
417: from PSB_PAY_ELEMENT_OPTIONS
418: where name = optname
419: and pay_element_id = elemid;
420:
421: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is

Line 505: select psb_pay_element_options_s.nextval seq

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
506: from dual;
507:
508: cursor c_elemrates_seq is
509: select psb_pay_element_rates_s.nextval seq

Line 615: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

611: for c_elemoptions_seq_rec in c_elemoptions_seq loop
612: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
613: end loop;
614:
615: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
616: (p_api_version => 1.0,
617: p_return_status => l_return_status,
618: p_msg_count => l_msg_count,
619: p_msg_data => l_msg_data,

Line 1218: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW

1214: for c_elemoptions_seq_rec in c_elemoptions_seq loop
1215: l_pay_element_option_id := c_elemoptions_seq_rec.seq;
1216: end loop;
1217:
1218: PSB_PAY_ELEMENT_OPTIONS_PVT.INSERT_ROW
1219: (p_api_version => 1.0,
1220: p_return_status => l_return_status,
1221: p_msg_count => l_msg_count,
1222: p_msg_data => l_msg_data,

Line 1492: from PSB_PAY_ELEMENT_OPTIONS a,

1488: and b.pay_element_id = elemid;
1489:
1490: cursor c_re_elemopt (elemid NUMBER, elemoptid NUMBER) is
1491: select a.pay_element_option_id
1492: from PSB_PAY_ELEMENT_OPTIONS a,
1493: PSB_PAY_ELEMENT_OPTIONS b
1494: where a.name = b.name
1495: and a.pay_element_id = elemid
1496: and b.pay_element_option_id = elemoptid

Line 1493: PSB_PAY_ELEMENT_OPTIONS b

1489:
1490: cursor c_re_elemopt (elemid NUMBER, elemoptid NUMBER) is
1491: select a.pay_element_option_id
1492: from PSB_PAY_ELEMENT_OPTIONS a,
1493: PSB_PAY_ELEMENT_OPTIONS b
1494: where a.name = b.name
1495: and a.pay_element_id = elemid
1496: and b.pay_element_option_id = elemoptid
1497: and nvl(a.sequence_number, -1) = nvl(b.sequence_number, -1);