APPS.HXC_RDB_POST_RETRIEVAL dependencies on PA_MOAC_UTILS

Line 62: AND ret.org_id = NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE(''ORG_ID''))

58: hxc_time_building_blocks SUM
59: WHERE ret.start_time BETWEEN :p_start_date
60: AND :p_end_date
61: AND ret.timecard_id = SUM.time_building_block_id
62: AND ret.org_id = NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE(''ORG_ID''))
63: PERSONCRITERIA
64: BATCHCRITERIA
65: ORGCRITERIA
66: ';

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

1988: -- Bug 12605349
1989: hr_utility.trace(' sql : '||l_pa_sql);
1990: hr_utility.trace(' start : '||TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1991: hr_utility.trace(' end : '||TO_DATE(p_end_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')));
1992: hr_utility.trace(' Org_id: '||NVL(Pa_Moac_Utils.Get_Current_Org_Id,FND_PROFILE.VALUE('ORG_ID')));
1993:
1994:
1995:
1996: OPEN l_pay_cursor FOR l_pa_sql USING TO_DATE(p_start_date,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK'))