APPS.PAY_IN_24QC_ER_RETURNS dependencies on FND_DATE

Line 105: AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)

101: AND action_context_type = 'PA'
102: AND action_information3 = p_gre_org_id
103: AND action_information2 = p_assess_period
104: AND pai.action_context_id= p_max_action_id
105: AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
106: AND action_information29 LIKE '%' || p_correction_type || '%';
107:
108: l_count NUMBER;
109: l_proc VARCHAR2(100);

Line 286: AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)

282: AND action_information2 = p_assess_period
283: AND pai.action_context_id = p_max_action_id
284: AND NVL(pai.action_information18, 'NC') <> 'NC'
285: AND pai.action_information29 like '%'||p_correction_type||'%'
286: AND fnd_date.canonical_to_date(pai.action_information5) <= fnd_date.CHARDATE_TO_DATE(SYSDATE)
287: );
288:
289: l_tds NUMBER := 0;
290: l_sur NUMBER := 0;