APPS.ARP_RECON_REP dependencies on FND_LOOKUPS

Line 625: from fnd_lookups

621: IF nvl(p_receivable_mode,'N') = 'Y' THEN
622: l_source_type_where := ' and ard.source_type in (''REC'',''UNPAIDREC'') ';
623: select meaning
624: into l_receivable_mode_meaning
625: from fnd_lookups
626: where lookup_type = 'YES_NO'
627: and lookup_code = 'Y';
628: ELSE
629: l_source_type_where := NULL;

Line 632: from fnd_lookups

628: ELSE
629: l_source_type_where := NULL;
630: select meaning
631: into l_receivable_mode_meaning
632: from fnd_lookups
633: where lookup_type = 'YES_NO'
634: and lookup_code = 'N';
635: END IF;
636:

Line 1149: from fnd_lookups

1145: IF nvl(p_receivable_mode,'N') = 'Y' THEN
1146: l_source_type_where := ' and ard.source_type in (''UNAPP'', ''UNID'',''ACC'',''OTHER ACC'') ';
1147: select meaning
1148: into l_receivable_mode_meaning
1149: from fnd_lookups
1150: where lookup_type = 'YES_NO'
1151: and lookup_code = 'Y';
1152: ELSE
1153: l_source_type_where := NULL;

Line 1156: from fnd_lookups

1152: ELSE
1153: l_source_type_where := NULL;
1154: select meaning
1155: into l_receivable_mode_meaning
1156: from fnd_lookups
1157: where lookup_type = 'YES_NO'
1158: and lookup_code = 'N';
1159: END IF;
1160:

Line 1738: from fnd_lookups

1734: '|| l_ard1_org_where || ')
1735: and ard.source_type in (''REMITTANCE'',''FACTOR'',''UNPAIDREC'')))';
1736: select meaning
1737: into l_receivable_mode_meaning
1738: from fnd_lookups
1739: where lookup_type = 'YES_NO'
1740: and lookup_code = 'Y';
1741: ELSE
1742: l_source_type_where := NULL;

Line 1745: from fnd_lookups

1741: ELSE
1742: l_source_type_where := NULL;
1743: select meaning
1744: into l_receivable_mode_meaning
1745: from fnd_lookups
1746: where lookup_type = 'YES_NO'
1747: and lookup_code = 'N';
1748: END IF;
1749:

Line 2225: from fnd_lookups

2221: IF nvl(p_receivable_mode,'N') = 'Y' THEN
2222: l_source_type_where := ' and ard.source_type in(''EXCH_GAIN'', ''EXCH_LOSS'')';
2223: select meaning
2224: into l_receivable_mode_meaning
2225: from fnd_lookups
2226: where lookup_type = 'YES_NO'
2227: and lookup_code = 'Y';
2228: ELSE
2229: l_source_type_where := NULL;

Line 2232: from fnd_lookups

2228: ELSE
2229: l_source_type_where := NULL;
2230: select meaning
2231: into l_receivable_mode_meaning
2232: from fnd_lookups
2233: where lookup_type = 'YES_NO'
2234: and lookup_code = 'N';
2235: END IF;
2236: