APPS.PV_PARTNER_ATTR_LOAD_PUB dependencies on DUAL

Line 95: select fnd_profile.value('ICX_DATE_FORMAT_MASK') into l_date_format from dual;

91: where attribute_id = l_attribute_id;
92:
93: if (l_display_style = 'DATE') then
94: begin
95: select fnd_profile.value('ICX_DATE_FORMAT_MASK') into l_date_format from dual;
96: l_target_date := to_date(l_attr_value_table(1).attr_value,l_date_format);
97: exception
98: when others then
99: l_target_date := null;

Line 751: --SELECT pv_account_number_s.nextval FROM dual;

747: party_id = l_party_id;
748:
749:
750: CURSOR C_acct_number IS
751: --SELECT pv_account_number_s.nextval FROM dual;
752: SELECT 1000 from dual;
753:
754:
755: l_bound Number;

Line 752: SELECT 1000 from dual;

748:
749:
750: CURSOR C_acct_number IS
751: --SELECT pv_account_number_s.nextval FROM dual;
752: SELECT 1000 from dual;
753:
754:
755: l_bound Number;
756: u_bound Number;

Line 1759: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;

1755:
1756:
1757: -- Get the value of Profile PV_IMPORT_COMMIT_SIZE.
1758: CURSOR l_get_commit_size_csr(cv_profile_name IN VARCHAR2) IS
1759: SELECT nvl(fnd_profile.value(cv_profile_name),0) from dual;
1760:
1761: CURSOR l_get_party_id(cv_orig_system IN VARCHAR2, cv_orig_system_ref IN VARCHAR2) IS
1762: SELECT
1763: HZ_PARTIES.PARTY_ID

Line 1842: select to_char(systimestamp,'yyddmmsssss') || '.log' into l_file_name from dual;

1838: else
1839: l_running_mode := p_mode;
1840: END IF;
1841: l_partnersProcessedCount := 0;
1842: select to_char(systimestamp,'yyddmmsssss') || '.log' into l_file_name from dual;
1843: -- l_file_name := 'myLogFile.log';
1844: open l_get_file_dir;
1845: fetch l_get_file_dir into l_out_dir, l_log_dir;
1846: close l_get_file_dir;