DBA Data[Home] [Help]

APPS.PAY_IN_REPORTS_PKG dependencies on DUAL

Line 4151: --Individual Month Record Determination

4147: dbms_lob.writeAppend(g_xml_data, length(l_tag), l_tag);
4148: pay_in_xml_utils.multiColumnar('Details',pay_in_xml_utils.gXMLTable,l_count,g_xml_data);
4149: l_count:=1;
4150: l_row_count:=0;
4151: --Individual Month Record Determination
4152: FOR i IN 3..12
4153: LOOP
4154: pay_in_utils.set_location(g_debug,l_procedure, 60);
4155: l_pf_salary_ptd :=0;

Line 5675: FROM dual;

5671: l_employee_contr := l_employee_contr + child_asg.employee_contr;
5672: l_employer_contr := l_employer_contr + child_asg.employer_contr;
5673: SELECT decode(child_asg.esi_coverage,'Yes','No','No','Yes')
5674: INTO l_esi_coverage
5675: FROM dual;
5676: EXIT;
5677: END LOOP;
5678: END LOOP;
5679: pay_in_utils.set_location(g_debug,l_procedure, 80);