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 568: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;

564: ,p_grp_param VARCHAR2
565: )
566: IS
567:
568: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;

Line 569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;

565: )
566: IS
567:
568: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
569: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
570: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;
571: l_inv_rule_name RA_RULES.NAME%TYPE;
572: l_inv_rule_type RA_RULES.TYPE%TYPE;
573: l_inv_rule_freq RA_RULES.FREQUENCY%TYPE;

Line 670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;

666: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
667: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
668: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;
669: v_send_entries PN_LEASE_DETAILS.send_entries%TYPE;
670: v_rec_account PN_DISTRIBUTIONS.account_id%TYPE;
671: v_gl_date RA_CUST_TRX_LINE_GL_DIST.gl_date%TYPE;
672: v_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
673: v_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
674: v_payment_purpose PN_PAYMENT_TERMS.payment_purpose_code%TYPE;

Line 1128: and UNEARN based on pn_distributions for each line

1124: /* if we reached here, we have a group worth inserting
1125: loop through the PL/SQL table and insert
1126: o one record per item in group into ra_interface_lines
1127: o distributions into ra_interface_distributions for REV
1128: and UNEARN based on pn_distributions for each line
1129: o ONLY one record in ra_interface_distributions for REC
1130: for ALL items
1131: */
1132:

Line 1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;

1904: v_pn_customer_site_use_id PN_PAYMENT_ITEMS.customer_site_use_id%TYPE;
1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;

Line 1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;

1905: v_pn_payment_schedule_id PN_PAYMENT_ITEMS.payment_schedule_id%TYPE;
1906: v_pn_accounted_date PN_PAYMENT_ITEMS.accounted_date%TYPE;
1907: v_pn_rate PN_PAYMENT_ITEMS.rate%TYPE;
1908: l_acnt_cls PN_DISTRIBUTIONS.account_class%TYPE;
1909: l_percent PN_DISTRIBUTIONS.percentage%TYPE;
1910: l_location_code PN_LOCATIONS.location_code%TYPE;
1911: l_inv_rule_name RA_RULES.name%TYPE;
1912: l_inv_rule_type RA_RULES.type%TYPE;
1913: l_inv_rule_freq RA_RULES.frequency%TYPE;