APPS.PA_PAY_INTERFACE dependencies on PA_EXPENDITURE_ITEMS_S

Line 4033: select pa_expenditure_items_s.nextval

4029: )
4030: LOOP
4031:
4032: i := i+1;
4033: select pa_expenditure_items_s.nextval
4034: into l_exp_item_id from dual;
4035:
4036:
4037: --Validate

Line 4517: select pa_expenditure_items_s.nextval

4513: )
4514: LOOP
4515:
4516: i := i+1;
4517: select pa_expenditure_items_s.nextval
4518: into l_exp_item_id from dual;
4519:
4520:
4521:

Line 5665: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID

5661: FROM PA_EXPENDITURE_ITEMS Ei3
5662: ,PA_EXPENDITURES E,
5663: PA_PAY_AUDIT AUD
5664: WHERE EI3.EXPENDITURE_ITEM_ID IN
5665: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5666: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=EXPENDITURE_ITEM_ID
5667: UNION
5668: SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5669: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=ADJUSTED_EXPENDITURE_ITEM_ID

Line 5668: SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID

5664: WHERE EI3.EXPENDITURE_ITEM_ID IN
5665: (SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5666: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=EXPENDITURE_ITEM_ID
5667: UNION
5668: SELECT EXPENDITURE_ITEM_ID FROM PA_EXPENDITURE_ITEMS START WITH EXPENDITURE_ITEM_ID= X.EXPENDITURE_ITEM_ID
5669: CONNECT BY PRIOR TRANSFERRED_FROM_EXP_ITEM_ID=ADJUSTED_EXPENDITURE_ITEM_ID
5670: )
5671: AND E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5672: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID