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 100: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)

96: WHERE paa.payroll_action_id = p_max_action_id
97: AND paa.assignment_action_id = pai.action_context_id)
98: AND pai.action_information1 = p_challan
99: AND pay_in_24q_er_returns.get_format_value(NVL(pai.action_information5,'0')) <> '0.00'
100: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
101: ORDER BY action_information1, action_information2 ASC;
102:
103: l_count NUMBER;
104: l_procedure varchar2(100);

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

171: AND action_context_type = 'PA'
172: AND action_information3 = p_gre_org_id
173: AND action_information2 = p_assess_period
174: AND pai.action_context_id= p_max_action_id
175: AND fnd_date.canonical_to_date(pai.action_information5)<=fnd_date.CHARDATE_TO_DATE(SYSDATE));
176:
177: l_tot NUMBER:= 0;
178: l_tds NUMBER:= 0;
179: l_sur NUMBER:= 0;

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

295: AND EXISTS ( SELECT 1
296: FROM pay_assignment_actions paa
297: WHERE paa.payroll_action_id = p_max_action_id
298: AND paa.assignment_action_id = pai.action_context_id)
299: -- AND fnd_date.canonical_to_date(pai.action_information4)<=fnd_date.CHARDATE_TO_DATE(SYSDATE)
300: ORDER BY action_information1, action_information2 ASC;
301:
302:
303: l_value29 VARCHAR2(20);