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_PAYSLIP_SIMULATION_MAIN dependencies on DUAL

Line 10: 04-FEB-2013 emunisek 120.1 After enabling Dual Checkin,

6: -----------
7: Date Name Vers Bug No Description
8: ----------- ---------- ----- ------- -------------------------------
9: 04-FEB-2013 emunisek 120.0 Created. Bug#16082307
10: 04-FEB-2013 emunisek 120.1 After enabling Dual Checkin,
11: arcsing in file to generate
12: Checkfile Equivalence
13: 05-FEB-2013 emunisek 120.2 Replaced sequence related to
14: PAY_ACTION_INFORMATION_S with

Line 3962: FROM DUAL;

3958: NULL, 'NULL',
3959: to_char(p_action_context_id))
3960: INTO l_action_information_id,
3961: l_action_context_id
3962: FROM DUAL;
3963:
3964: build_sql(sqlstr, l_cntr_sql, 'declare l_org_id varchar2(100);');
3965:
3966: build_sql(sqlstr, l_cntr_sql, 'lt_pay_date DATE := TO_DATE(''0001/01/01'',''YYYY/MM/DD'');');

Line 4048: 'hla.LOCATION_CODE=csr_get_sim_arch_info_rec.action_information30),''K'') INTO lt_rate_flg FROM DUAL;');

4044: 'WHERE hle.information_type = ''HR_SELF_SERVICE_LOC_PREFERENCE''');
4045:
4046: build_sql(sqlstr,l_cntr_sql,
4047: 'AND hle.lei_information1 =''PAYSLIP'' AND hla.LOCATION_ID = hle.LOCATION_ID AND '||
4048: 'hla.LOCATION_CODE=csr_get_sim_arch_info_rec.action_information30),''K'') INTO lt_rate_flg FROM DUAL;');
4049:
4050: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN');
4051:
4052: build_sql(sqlstr,l_cntr_sql,

Line 4056: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');

4052: build_sql(sqlstr,l_cntr_sql,
4053: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
4054: 'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
4055: build_sql(sqlstr,l_cntr_sql,
4056: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL ;');
4057: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');
4058: build_sql(sqlstr,l_cntr_sql,
4059: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
4060: 'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');

Line 4062: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL;');

4058: build_sql(sqlstr,l_cntr_sql,
4059: ' SELECT NVL((select org_information13 FROM hr_organization_information '||
4060: 'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
4061: build_sql(sqlstr,l_cntr_sql,
4062: 'AND organization_id=csr_get_sim_arch_info_rec.action_information2),''K'') INTO lt_rate_flg FROM DUAL;');
4063: build_sql(sqlstr,l_cntr_sql,'IF lt_rate_flg = ''K'' THEN ');
4064: build_sql(sqlstr,l_cntr_sql,' lt_rate_flg := ''N'';');
4065: build_sql(sqlstr,l_cntr_sql,'END IF;'||'END IF;'||'END IF;');
4066: build_sql(sqlstr,l_cntr_sql,'pay_payroll_xml_extract_pkg.load_xml(''D'', ''RATE_DISP_FLG'', lt_rate_flg);');

Line 4077: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');

4073: build_sql(sqlstr, l_cntr_sql, 'lt_state_cd := substr(csr_get_sim_arch_info_rec.action_information21,1,2);');
4074: build_sql(sqlstr, l_cntr_sql, 'lt_element_type := csr_get_sim_arch_info_rec.action_information20;');
4075: build_sql(sqlstr, l_cntr_sql,
4076: 'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
4077: ',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
4078: build_sql(sqlstr,l_cntr_sql,
4079: ' pay_payroll_xml_extract_pkg.load_xml(''D'', ''DATE_DISP_FLG'', lt_ret_val);');
4080:
4081: END IF;