APPS.PN_EXP_TO_AR dependencies on PN_LOCATIONS

Line 48: FROM pn_locations_all pl

44: WHERE term_id = p_term_id;
45:
46: CURSOR get_loc_code(p_location_id number) is
47: SELECT pl.location_code
48: FROM pn_locations_all pl
49: WHERE pl.location_id = p_location_id;
50:
51: CURSOR get_batch_source_name is
52: SELECT name,

Line 566: l_location_code PN_LOCATIONS.LOCATION_CODE%TYPE;

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;
570: l_acc_rule_name RA_RULES.NAME%TYPE;

Line 662: v_location_id PN_LOCATIONS.LOCATION_ID%TYPE;

658: v_transaction_date PN_PAYMENT_ITEMS.due_date%TYPE;
659: v_normalize PN_PAYMENT_TERMS.normalize%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;

Line 1864: l_location_code PN_LOCATIONS.location_code%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;
1868: l_acc_rule_name RA_RULES.name%TYPE;

Line 1913: v_location_id PN_LOCATIONS.location_id%TYPE;

1909: pn_mo_cache_utils.get_current_org_id));
1910: l_func_curr_code GL_SETS_OF_BOOKS.currency_code%TYPE;
1911: l_conv_rate_type PN_CURRENCIES.conversion_type%TYPE;
1912: l_conv_rate PN_PAYMENT_ITEMS.rate%TYPE;
1913: v_location_id PN_LOCATIONS.location_id%TYPE;
1914: l_send_flag PN_LEASE_DETAILS_ALL.send_entries%TYPE := 'Y';
1915: l_lease_id NUMBER := 0;
1916: v_pur_code PN_PAYMENT_TERMS.payment_purpose_code%TYPE;
1917: v_pur_type_code PN_PAYMENT_TERMS.payment_term_type_code%TYPE;