DBA Data[Home] [Help]

APPS.PA_REVERSE_COSTED_LAB dependencies on PA_PAY_PROJ_STATUS_ALL

Line 580: write_log(LOG, 'Update status on PA_PAY_PROJ_STATUS_ALL');

576: IF l_result = 0
577: THEN
578: IF G_debug_mode = 'Y'
579: THEN
580: write_log(LOG, 'Update status on PA_PAY_PROJ_STATUS_ALL');
581: END IF;
582: UPDATE PA_PAY_PROJ_STATUS_ALL
583: SET PROJECT_ROLLBACK_STATUS_IND='Y',
584: LAST_UPDATED_BY=g_user_id

Line 582: UPDATE PA_PAY_PROJ_STATUS_ALL

578: IF G_debug_mode = 'Y'
579: THEN
580: write_log(LOG, 'Update status on PA_PAY_PROJ_STATUS_ALL');
581: END IF;
582: UPDATE PA_PAY_PROJ_STATUS_ALL
583: SET PROJECT_ROLLBACK_STATUS_IND='Y',
584: LAST_UPDATED_BY=g_user_id
585: WHERE INTERFACE_RUN_ID=l_Interface_run_idTab(i)
586: AND PERSON_ID =l_PersonIdTab(i) ;

Line 871: pa_pay_proj_status_all ps

867: 'N' transfered_to_prj
868: FROM
869: pa_pay_audit_all aud ,
870: pay_costing_projects_v src,
871: pa_pay_proj_status_all ps
872: WHERE
873: aud.interface_run_id = p_interface_run_id
874: AND ps.interface_run_id = aud.interface_run_id
875: AND ps.person_id = p_person_id