APPS.PN_EXP_TO_AR dependencies on PN_DISTRIBUTIONS

Line 9: FROM pn_distributions_all

5: CURSOR get_dist(p_term_id NUMBER) IS
6: SELECT account_id,
7: account_class,
8: percentage
9: FROM pn_distributions_all
10: WHERE payment_term_id = p_term_id;
11:
12: CURSOR get_desc (p_lookup_code varchar2) is
13: SELECT meaning

Line 66: FROM pn_distributions_all

62: WHERE vat_tax_id = p_tax_code_id;
63:
64: CURSOR acnt_cls_cur(p_term_id NUMBER) IS
65: SELECT account_class
66: FROM pn_distributions_all
67: WHERE payment_term_id = p_term_id;
68:
69: CURSOR gl_segment_check IS
70: SELECT 'Y'

Line 249: PN_DISTRIBUTIONS_ALL pd, RA_CUST_TRX_TYPES_ALL cust_trx,

245: PN_LEASE_DETAILS_ALL pld, HZ_CUST_SITE_USES_ALL hzc,
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''

Line 564: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;

560: ,p_grp_param VARCHAR2
561: )
562: IS
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;

Line 565: l_percent PN_DISTRIBUTIONS.percentage%TYPE;

561: )
562: IS
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;

Line 664: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;

660: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
661: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
662: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
663: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;
664: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
665: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
666: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
667: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 1113: and UNEARN based on pn_distributions for each line

1109: /* if we reached here, we have a group worth inserting
1110: loop through the PL/SQL table and insert
1111: o one record per item in group into ra_interface_lines
1112: o distributions into ra_interface_distributions for REV
1113: and UNEARN based on pn_distributions for each line
1114: o ONLY one record in ra_interface_distributions for REC
1115: for ALL items
1116: */
1117:

Line 1862: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;

1858: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1859: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1860: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%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;

Line 1863: l_percent PN_DISTRIBUTIONS.percentage%TYPE;

1859: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1860: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%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;