APPS.FII_AR_REC_AGING_PKG dependencies on DUAL

Line 827: FROM dual

823: l_bucket_rec BUCKET_REC;
824:
825: CURSOR rec_aging_cursor IS
826: SELECT 7, l_data_rec(1).l_label_7, l_data_rec(1).l_pdue_bkt7_amt
827: FROM dual
828: UNION
829: SELECT 6, l_data_rec(1).l_label_6, l_data_rec(1).l_pdue_bkt6_amt
830: FROM dual
831: UNION

Line 830: FROM dual

826: SELECT 7, l_data_rec(1).l_label_7, l_data_rec(1).l_pdue_bkt7_amt
827: FROM dual
828: UNION
829: SELECT 6, l_data_rec(1).l_label_6, l_data_rec(1).l_pdue_bkt6_amt
830: FROM dual
831: UNION
832: SELECT 5, l_data_rec(1).l_label_5, l_data_rec(1).l_pdue_bkt5_amt
833: FROM dual
834: UNION

Line 833: FROM dual

829: SELECT 6, l_data_rec(1).l_label_6, l_data_rec(1).l_pdue_bkt6_amt
830: FROM dual
831: UNION
832: SELECT 5, l_data_rec(1).l_label_5, l_data_rec(1).l_pdue_bkt5_amt
833: FROM dual
834: UNION
835: SELECT 4, l_data_rec(1).l_label_4, l_data_rec(1).l_pdue_bkt4_amt
836: FROM dual
837: UNION

Line 836: FROM dual

832: SELECT 5, l_data_rec(1).l_label_5, l_data_rec(1).l_pdue_bkt5_amt
833: FROM dual
834: UNION
835: SELECT 4, l_data_rec(1).l_label_4, l_data_rec(1).l_pdue_bkt4_amt
836: FROM dual
837: UNION
838: SELECT 3, l_data_rec(1).l_label_3, l_data_rec(1).l_pdue_bkt3_amt
839: FROM dual
840: UNION

Line 839: FROM dual

835: SELECT 4, l_data_rec(1).l_label_4, l_data_rec(1).l_pdue_bkt4_amt
836: FROM dual
837: UNION
838: SELECT 3, l_data_rec(1).l_label_3, l_data_rec(1).l_pdue_bkt3_amt
839: FROM dual
840: UNION
841: SELECT 2, l_data_rec(1).l_label_2, l_data_rec(1).l_pdue_bkt2_amt
842: FROM dual
843: UNION

Line 842: FROM dual

838: SELECT 3, l_data_rec(1).l_label_3, l_data_rec(1).l_pdue_bkt3_amt
839: FROM dual
840: UNION
841: SELECT 2, l_data_rec(1).l_label_2, l_data_rec(1).l_pdue_bkt2_amt
842: FROM dual
843: UNION
844: SELECT 1, l_data_rec(1).l_label_1, l_data_rec(1).l_pdue_bkt1_amt
845: FROM dual
846: UNION

Line 845: FROM dual

841: SELECT 2, l_data_rec(1).l_label_2, l_data_rec(1).l_pdue_bkt2_amt
842: FROM dual
843: UNION
844: SELECT 1, l_data_rec(1).l_label_1, l_data_rec(1).l_pdue_bkt1_amt
845: FROM dual
846: UNION
847: SELECT 0, l_data_rec(1).l_label_0, l_data_rec(1).l_curr_rec_amt
848: FROM dual;
849:

Line 848: FROM dual;

844: SELECT 1, l_data_rec(1).l_label_1, l_data_rec(1).l_pdue_bkt1_amt
845: FROM dual
846: UNION
847: SELECT 0, l_data_rec(1).l_label_0, l_data_rec(1).l_curr_rec_amt
848: FROM dual;
849:
850: l_fii_user_id NUMBER(15);
851: l_fii_login_id NUMBER(15);
852: