1985:
1986: END IF;
1987:
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:
1986: END IF;
1987:
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:
1987:
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:
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'))
2004: rettab,
2005: starttab,
2006: stoptab LIMIT 500;
2007: -- Bug 12605349
2008: hr_utility.trace(' l_pay_cursor count: '||l_pay_cursor%rowcount);
2009:
2010: EXIT WHEN tctab.COUNT = 0;
2011:
2012: FORALL i IN tctab.FIRST..tctab.LAST