APPS.ARP_RECON_REP dependencies on FND_LOOKUPS

Line 626: from fnd_lookups

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

Line 633: from fnd_lookups

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

Line 1175: from fnd_lookups

1171: l_source_type_ard_where := ' and ard.source_type in (''UNAPP'', ''UNID'',''ACC'',''OTHER ACC'') ';
1172:
1173: select meaning
1174: into l_receivable_mode_meaning
1175: from fnd_lookups
1176: where lookup_type = 'YES_NO'
1177: and lookup_code = 'Y';
1178: ELSE
1179: l_source_type_where := NULL;

Line 1182: from fnd_lookups

1178: ELSE
1179: l_source_type_where := NULL;
1180: select meaning
1181: into l_receivable_mode_meaning
1182: from fnd_lookups
1183: where lookup_type = 'YES_NO'
1184: and lookup_code = 'N';
1185: END IF;
1186:

Line 2426: from fnd_lookups

2422: and ard.source_type in (''REMITTANCE'',''FACTOR'',''UNPAIDREC'')))';
2423:
2424: select meaning
2425: into l_receivable_mode_meaning
2426: from fnd_lookups
2427: where lookup_type = 'YES_NO'
2428: and lookup_code = 'Y';
2429: ELSE
2430: l_source_type_where := NULL;

Line 2433: from fnd_lookups

2429: ELSE
2430: l_source_type_where := NULL;
2431: select meaning
2432: into l_receivable_mode_meaning
2433: from fnd_lookups
2434: where lookup_type = 'YES_NO'
2435: and lookup_code = 'N';
2436: END IF;
2437:

Line 3438: from fnd_lookups

3434: IF nvl(p_receivable_mode,'N') = 'Y' THEN
3435: l_source_type_where := ' and ard.source_type in(''EXCH_GAIN'', ''EXCH_LOSS'')';
3436: select meaning
3437: into l_receivable_mode_meaning
3438: from fnd_lookups
3439: where lookup_type = 'YES_NO'
3440: and lookup_code = 'Y';
3441: ELSE
3442: l_source_type_where := NULL;

Line 3445: from fnd_lookups

3441: ELSE
3442: l_source_type_where := NULL;
3443: select meaning
3444: into l_receivable_mode_meaning
3445: from fnd_lookups
3446: where lookup_type = 'YES_NO'
3447: and lookup_code = 'N';
3448: END IF;
3449: