APPS.HXC_RDB_PRE_RETRIEVAL dependencies on PA_MOAC_UTILS

Line 779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));

775:
776: -- Bug 12605349
777: hr_utility.trace(' sql: '||l_pa_sql);
778: hr_utility.trace(' Since_date: '||FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')));
779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

Line 783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

779: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
780:
781: OPEN l_pa_cursor FOR l_pa_sql
782: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
783: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));
784: LOOP
785: FETCH l_pa_cursor BULK COLLECT INTO restab,
786: tctab,
787: stattab,

Line 830: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));

826: 'ret.last_update_date < FND_DATE.canonical_to_date');
827:
828: OPEN l_pa_cursor FOR l_pa_sql
829: USING FND_DATE.date_to_canonical( SYSDATE-FND_PROFILE.VALUE('HXC_RETRIEVAL_CHANGES_DATE')),
830: NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID'));
831:
832: LOOP
833: FETCH l_pa_cursor BULK COLLECT INTO restab,
834: tctab,