DBA Data[Home] [Help]

APPS.PAY_IN_REPORTS_PKG dependencies on DUAL

Line 3435: --Individual Month Record Determination

3431: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
3432: pay_in_xml_utils.multiColumnar('Details',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
3433: l_count:=1;
3434: l_row_count:=0;
3435: --Individual Month Record Determination
3436: FOR i IN 3..12
3437: LOOP
3438: pay_in_utils.set_location(g_debug,l_procedure, 60);
3439: l_pf_salary_ptd :=0;

Line 4956: FROM dual;

4952: l_employee_contr := l_employee_contr + child_asg.employee_contr;
4953: l_employer_contr := l_employer_contr + child_asg.employer_contr;
4954: SELECT decode(child_asg.esi_coverage,'Yes','No','No','Yes')
4955: INTO l_esi_coverage
4956: FROM dual;
4957: EXIT;
4958: END LOOP;
4959: END LOOP;
4960: pay_in_utils.set_location(g_debug,l_procedure, 80);