eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_PSD_GENERIC_EXTRACT dependencies on DUAL

Line 601: FROM dual;

597: Consturct XML Elements using all the RA record data items stored in the
598: ''|| EOL ||
599: */
600: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
601: FROM dual;
602:
603: l_final_xml_string := ''||EOL;
604:
605: FOR I IN 1 .. g_ra_no_of_tag LOOP

Line 840: from dual;

836: from pay_payroll_Actions ppa where payroll_action_id= p_payroll_action_id;*/
837:
838: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
839: 'TRANSFER_PERIOD_TYPE') into l_period_type
840: from dual;
841:
842: --Added for the Bug 14799833
843: if l_period_type = 'Yearly' then
844: l_reporting_period := p_reporting_year||'12';

Line 1084: FROM dual;

1080: g_re_record(ER_SUCCESS_PSD_CODE).employer_data := 'SUCCESS'||g_re_record(ER_PSD_CODE).employer_data;
1081: g_re_record(ER_SUCCESS_PSD_CODE).employer_tag := ltr_re_data_tag(ER_SUCCESS_PSD_CODE);
1082:
1083: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
1084: FROM dual;
1085: l_final_xml_string := ''||EOL;
1086:
1087: FOR I IN 1 .. g_re_no_of_tag LOOP
1088: l_final_xml_string := l_final_xml_string || '<'||g_re_record(I).employer_tag||'>'||

Line 1387: from dual;

1383:
1384:
1385: select pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'),
1386: 'TRANSFER_PERIOD_TYPE') into l_period_type
1387: from dual;
1388:
1389: --Added for the Bug 14799833--Modified for the Bug 15960706
1390: if l_period_type = 'Yearly' then
1391: l_reporting_period := '12'||p_reporting_year;

Line 1394: select substr( p_jurisdiction_code, 4,6) into l_ee_residence_psd_code from dual;

1390: if l_period_type = 'Yearly' then
1391: l_reporting_period := '12'||p_reporting_year;
1392: end if;
1393:
1394: select substr( p_jurisdiction_code, 4,6) into l_ee_residence_psd_code from dual;
1395: select substr( p_jurisdiction_code, 11,6) into l_ee_work_psd_code from dual;
1396:
1397: --
1398: -- Fetch SRS Parameter

Line 1395: select substr( p_jurisdiction_code, 11,6) into l_ee_work_psd_code from dual;

1391: l_reporting_period := '12'||p_reporting_year;
1392: end if;
1393:
1394: select substr( p_jurisdiction_code, 4,6) into l_ee_residence_psd_code from dual;
1395: select substr( p_jurisdiction_code, 11,6) into l_ee_work_psd_code from dual;
1396:
1397: --
1398: -- Fetch SRS Parameter
1399: --

Line 1596: from dual;

1592: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1593: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1594: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1595: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1596: from dual;
1597: END IF;
1598: ELSIF ltr_ue_name_table(J).ue_data_level ='STATE' THEN
1599: ltr_ue_name_table(j).ue_value :=
1600: hr_us_w2_rep.get_w2_arch_bal(

Line 1619: from dual;

1615: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1616: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1617: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1618: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1619: from dual;
1620: END IF;
1621: ELSIF ltr_ue_name_table(J).ue_data_level ='PSD' THEN
1622: ltr_ue_name_table(j).ue_value :=
1623: hr_us_w2_rep.get_w2_arch_bal(

Line 1640: from dual;

1636: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500);*/
1637: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1638: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1639: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1640: from dual;
1641: END IF;
1642: --Added for the Bug 14799833
1643: ELSIF ltr_ue_name_table(J).ue_data_level ='PSD_YTD' THEN
1644:

Line 1652: from dual;

1648: l_status := 'FAILED';
1649: select SUBSTR(l_status_description || 'Archive Item ' || ltr_ue_name_table(j).ue_name || ' has negative balance(' || trunc(ltr_ue_name_table(j).ue_value)||
1650: decode(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),0,'.00',rpad(abs(ltr_ue_name_table(j).ue_value)-abs(trunc(ltr_ue_name_table(j).ue_value)),3,'0'))||').'
1651: ||fnd_global.local_chr(13) || fnd_global.local_chr(10)||' ',1,1500) into l_status_description
1652: from dual;
1653: END IF;
1654: ELSIF ltr_ue_name_table(J).ue_data_level ='GRE' THEN
1655: ltr_ue_name_table(j).ue_value :=
1656: hr_us_w2_rep.get_state_item(

Line 1711: FROM dual;

1707: --
1708: pay_us_psd_generic_extract.populate_ee_data_tag;
1709:
1710: SELECT fnd_global.local_chr(13) || fnd_global.local_chr(10) INTO EOL
1711: FROM dual;
1712:
1713: /* Initialize with Default Value */
1714:
1715: FOR I IN ltr_ee_data_tag.first .. ltr_ee_data_tag.last