DBA Data[Home] [Help]

APPS.PA_EXP_COPY dependencies on PA_EXPENDITURES_S

Line 540: /* Bug 1118913 Removed pa_expenditures_s.nextval new_exp_id from

536:
537: l_org_id NUMBER := pa_moac_utils.get_current_org_id;
538:
539: /* Bug 954856 Added ORDER BY expenditure_id to cursor getEXP */
540: /* Bug 1118913 Removed pa_expenditures_s.nextval new_exp_id from
541: cursor. Whereever EXP.new_exp_id change to
542: new_exp_id */
543:
544: CURSOR getEXP IS

Line 634: SELECT pa_expenditures_s.nextval

630: -- Earlier the new expenditure id was generated
631: -- in the select statement. But there was problem
632: -- using the sequence generator in the SELECT statement
633:
634: SELECT pa_expenditures_s.nextval
635: INTO new_exp_id
636: FROM DUAL ;
637:
638: --

Line 876: , pa_expenditures_s.nextval new_exp_id

872:
873: CURSOR RevExp is
874: SELECT
875: e.expenditure_id orig_exp_id
876: , pa_expenditures_s.nextval new_exp_id
877: , e.expenditure_ending_date
878: , e.description
879: , e.incurred_by_person_id person_id
880: , e.incurred_by_organization_id inc_by_org_id