DBA Data[Home] [Help]

APPS.PA_PAY_INTERFACE dependencies on PA_EXPENDITURES_ALL

Line 3893: l_expenditure_id pa_expenditures_all.expenditure_id%type;

3889: */
3890:
3891: PROCEDURE process_burden IS
3892: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
3893: l_expenditure_id pa_expenditures_all.expenditure_id%type;
3894: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
3895: i PLS_INTEGER;
3896: l_status VARCHAR2(100);
3897: l_msg_application VARCHAR2(10);

Line 4363: l_expenditure_id pa_expenditures_all.expenditure_id%type;

4359: */
4360:
4361: PROCEDURE process_misc IS
4362: l_exp_group pa_expenditure_groups_all.expenditure_group%type;
4363: l_expenditure_id pa_expenditures_all.expenditure_id%type;
4364: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
4365: i PLS_INTEGER;
4366: l_status VARCHAR2(100);
4367: l_msg_application VARCHAR2(10);

Line 5574: PA_EXPENDITURES_ALL E,

5570: EI2.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5571: WHERE EI2.EXPENDITURE_ITEM_ID IN
5572: ( SELECT EI.EXPENDITURE_ITEM_ID
5573: FROM PA_EXPENDITURE_ITEMS_ALL EI ,
5574: PA_EXPENDITURES_ALL E,
5575: PA_PAY_AUDIT AUD
5576: WHERE E.INCURRED_BY_PERSON_ID = G_PERSON_ID
5577: AND AUD.INTERFACE_RUN_ID = G_INTERFACE_RUN_ID
5578: AND EI.EXPENDITURE_ID = E.EXPENDITURE_ID