APPS.AR_ARXRJR_XMLP_PKG dependencies on DUAL

Line 70: into p_cr_where,p_cust_where,p_site_where from dual;

66: p_cust_where:=xla_mo_reporting_api.get_predicate('cust_acct',null);
67: select replace(p_cr_where,':p_reporting_entity_id',p_reporting_context),
68: replace(p_cust_where,':p_reporting_entity_id',p_reporting_context),
69: replace(p_site_where,':p_reporting_entity_id',p_reporting_context)
70: into p_cr_where,p_cust_where,p_site_where from dual;
71:
72: If p_reporting_level <>3000 then
73: begin
74: select substrb(meaning,1,10) into reporting_context_name from ar_lookups

Line 100: into lp_customer_name_low from dual;

96:
97: if p_in_customer_name_low is not null then
98: lp_customer_name_low := ' and party.party_name >=' || ''':p_in_customer_name_low''';
99: select replace(lp_customer_name_low,':p_in_customer_name_low',p_in_customer_name_low)
100: into lp_customer_name_low from dual;
101: end if;
102:
103: if p_in_customer_name_high is not null then
104: lp_customer_name_high := ' and party.party_name <= '|| ''':p_in_customer_name_high''';

Line 106: into lp_customer_name_high from dual;

102:
103: if p_in_customer_name_high is not null then
104: lp_customer_name_high := ' and party.party_name <= '|| ''':p_in_customer_name_high''';
105: select replace(lp_customer_name_high,':p_in_customer_name_high',p_in_customer_name_high)
106: into lp_customer_name_high from dual;
107: end if;
108:
109:
110: if p_in_customer_num_low is not null then

Line 113: into lp_customer_num_low from dual;

109:
110: if p_in_customer_num_low is not null then
111: lp_customer_num_low := ' and cust_acct.account_number>='||''':p_in_customer_num_low''';
112: select replace(lp_customer_num_low,':p_in_customer_num_low',p_in_customer_num_low)
113: into lp_customer_num_low from dual;
114: end if;
115:
116: if p_in_customer_num_high is not null then
117: lp_customer_num_high := ' and cust_acct.account_number<='||''':p_in_customer_num_high''';

Line 119: into lp_customer_num_high from dual;

115:
116: if p_in_customer_num_high is not null then
117: lp_customer_num_high := ' and cust_acct.account_number<='||''':p_in_customer_num_high''';
118: select replace(lp_customer_num_high,':p_in_customer_num_high',p_in_customer_num_high)
119: into lp_customer_num_high from dual;
120: end if;
121:
122:
123: null;