DBA Data[Home] [Help]

APPS.IGW_GENERATE_PERIODS dependencies on DUAL

Line 890: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;

886: ,sysdate
887: ,fnd_global.user_id
888: ,fnd_global.login_id);
889:
890: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
891: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
892: create_budget_personnel_amts (
893: l_dummy_personnel_id
894: ,l_rate_class_id_oh

Line 914: from dual;

910: END LOOP; --for rec_personnel_budget
911: end if;
912: select igw_budget_details_s.currval
913: into l_line_item_seq
914: from dual;
915:
916:
917: update igw_budget_details_cal_amts pdc
918: set pdc.calculated_cost =

Line 1740: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;

1736: ,sysdate
1737: ,fnd_global.user_id
1738: ,fnd_global.login_id);
1739:
1740: select igw_budget_personnel_s.currval into l_dummy_personnel_id from dual;
1741: if l_rate_class_id_oh is not null and l_rate_type_id_oh is not null then
1742: create_budget_personnel_amts (
1743: l_dummy_personnel_id
1744: ,l_rate_class_id_oh

Line 1766: from dual;

1762: end if;
1763:
1764: select igw_budget_details_s.currval
1765: into l_line_item_seq
1766: from dual;
1767:
1768: update igw_budget_details_cal_amts pdc
1769: set pdc.calculated_cost =
1770: (select nvl(sum(ppc.calculated_cost),0)