APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_DATE

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

30: AND action_context_type = 'PA'
31: AND action_information3 = p_gre_org_id
32: AND action_information2 = p_assess_period
33: AND pai.action_context_id= p_max_action_id
34: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE);
35:
36: l_count NUMBER;
37: l_procedure varchar2(100);
38:

Line 122: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)

118: WHERE paa.payroll_action_id = p_max_action_id
119: AND paa.assignment_action_id = pai.action_context_id)
120: AND pai.action_information1 = p_challan
121: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
122: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
123: ORDER BY action_information1, action_information2 ASC;
124:
125: l_count NUMBER;
126: l_procedure varchar2(100);

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

193: AND action_context_type = 'PA'
194: AND action_information3 = p_gre_org_id
195: AND action_information2 = p_assess_period
196: AND pai.action_context_id= p_max_action_id
197: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE));
198:
199: l_tot NUMBER:= 0;
200: l_tds NUMBER:= 0;
201: l_sur NUMBER:= 0;

Line 327: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)

323: AND EXISTS ( SELECT 1
324: FROM pay_assignment_actions paa
325: WHERE paa.payroll_action_id = p_max_action_id
326: AND paa.assignment_action_id = pai.action_context_id)
327: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
328: ORDER BY action_information1, action_information2 ASC;
329:
330:
331: l_value29 VARCHAR2(20);