APPS.PSB_WORKSHEET_CONSOLIDATE dependencies on PSB_PAY_ELEMENT_RATES

Line 423: from PSB_PAY_ELEMENT_RATES

419: and pay_element_id = elemid;
420:
421: cursor c_elemrates (elemid NUMBER, elemoptionid NUMBER) is
422: select *
423: from PSB_PAY_ELEMENT_RATES
424: where (worksheet_id is null or worksheet_id = p_local_worksheet_id)
425: and pay_element_option_id = elemoptionid
426: and pay_element_id = elemid;
427:

Line 430: from PSB_PAY_ELEMENT_RATES

426: and pay_element_id = elemid;
427:
428: cursor c_elemrates_nooptions (elemid NUMBER) is
429: select *
430: from PSB_PAY_ELEMENT_RATES
431: where (worksheet_id is null or worksheet_id = p_local_worksheet_id)
432: and pay_element_id = elemid;
433:
434: cursor c_possetgrp (elemid NUMBER) is

Line 509: select psb_pay_element_rates_s.nextval seq

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
510: from dual;
511:
512: cursor c_posset_seq is
513: select PSB_ACCOUNT_POSITION_SETS_S.NEXTVAL seq

Line 647: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row

643: else
644: l_worksheet_id := g_global_worksheet_id;
645: end if;
646:
647: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row
648: (p_api_version => 1.0,
649: p_return_status => l_return_status,
650: p_msg_count => l_msg_count,
651: p_msg_data => l_msg_data,

Line 696: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row

692: else
693: l_worksheet_id := g_global_worksheet_id;
694: end if;
695:
696: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row
697: (p_api_version => 1.0,
698: p_return_status => l_return_status,
699: p_msg_count => l_msg_count,
700: p_msg_data => l_msg_data,

Line 1250: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row

1246: for c_elemrates_seq_rec in c_elemrates_seq loop
1247: l_pay_element_rate_id := c_elemrates_seq_rec.seq;
1248: end loop;
1249:
1250: PSB_PAY_ELEMENT_RATES_PVT.Insert_Row
1251: (p_api_version => 1.0,
1252: p_return_status => l_return_status,
1253: p_msg_count => l_msg_count,
1254: p_msg_data => l_msg_data,