18: CURSOR get_rule_name (p_rule_id number) is
19: SELECT name,
20: type,
21: frequency
22: FROM ra_rules
23: WHERE rule_id = p_rule_id;
24:
25: CURSOR get_receipt_name (p_receipt_method_id number) is
26: SELECT name
246: HZ_CUST_SITE_USES_ALL hzc1, HZ_PARTIES party,
247: HZ_CUST_ACCOUNTS_ALL cust_acc, FND_LOOKUPS type_lookup,
248: FND_LOOKUPS purpose_lookup, HR_OPERATING_UNITS ou,
249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,
250: RA_RULES rr
251: WHERE pi.payment_term_id = pt.payment_term_id
252: AND pi.payment_schedule_id = ps.payment_schedule_id
253: AND pi.export_to_ar_flag = ''Y''
254: AND pi.payment_item_type_lookup_code = ''CASH''
563:
564: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
565: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
566: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
567: l_inv_rule_name RA_RULES.NAME%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
564: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
565: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
566: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
567: l_inv_rule_name RA_RULES.NAME%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
565: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
566: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
567: l_inv_rule_name RA_RULES.NAME%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
566: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
567: l_inv_rule_name RA_RULES.NAME%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
567: l_inv_rule_name RA_RULES.NAME%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
568: l_inv_rule_type RA_RULES.TYPE%TYPE;
569: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;
570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%TYPE;
573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
576: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;
1861: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1862: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1863: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1864: l_location_code PN_LOCATIONS.location_code%TYPE;
1865: l_inv_rule_name RA_RULES.name%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1862: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1863: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1864: l_location_code PN_LOCATIONS.location_code%TYPE;
1865: l_inv_rule_name RA_RULES.name%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1863: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1864: l_location_code PN_LOCATIONS.location_code%TYPE;
1865: l_inv_rule_name RA_RULES.name%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1864: l_location_code PN_LOCATIONS.location_code%TYPE;
1865: l_inv_rule_name RA_RULES.name%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1865: l_inv_rule_name RA_RULES.name%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1866: l_inv_rule_type RA_RULES.type%TYPE;
1867: l_inv_rule_freq RA_RULES.frequency%TYPE;
1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%TYPE;
1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1874: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;