DBA Data[Home] [Help]

APPS.AR_AGING_BUCKETS_PKG dependencies on AR_AGING_BUCKET_LINES

Line 197: from ar_aging_bucket_lines lines,

193: FUNCTION get_report_heading RETURN VARCHAR2 IS
194: CURSOR buc_info_cur IS
195: select report_heading1,
196: report_heading2
197: from ar_aging_bucket_lines lines,
198: ar_aging_buckets buckets
199: where lines.aging_bucket_id = buckets.aging_bucket_id
200: and UPPER(buckets.bucket_name) = UPPER(pg_in_bucket_type_low)
201: and NVL(buckets.status,'A') = 'A'

Line 1833: from ar_aging_bucket_lines lines,

1829: type,
1830: DECODE(type,'DISPUTE_ONLY',type,
1831: 'PENDADJ_ONLY',type,
1832: 'DISPUTE_PENDADJ',type,null) bucket_category
1833: from ar_aging_bucket_lines lines,
1834: ar_aging_buckets buckets
1835: where lines.aging_bucket_id = buckets.aging_bucket_id
1836: and upper(buckets.bucket_name) = upper(pg_in_bucket_type_low)
1837: and nvl(buckets.status,'A') = 'A'