eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_EXP_COPY dependencies on PA_EXPENDITURES_S

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

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

Line 637: SELECT pa_expenditures_s.nextval

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

Line 879: , pa_expenditures_s.nextval new_exp_id

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