APPS.PNP_UTIL_FUNC dependencies on PN_CURRENCIES

Line 49: l_conv_type PN_CURRENCIES.CONVERSION_TYPE%TYPE;

45: IS
46:
47: total_item_amount NUMBER := 0;
48: l_conv_date DATE;
49: l_conv_type PN_CURRENCIES.CONVERSION_TYPE%TYPE;
50: l_org_id NUMBER(15);
51:
52: CURSOR amounts_cursor IS
53: SELECT actual_amount, accounted_amount, currency_code, due_date, rate, org_id

Line 6386: | THEN looks at pn_currencies AND RETURNs Conversion Rate Type.

6382: |
6383: | DESCRIPTION
6384: | This FUNCTION check for Conversion Rate Type for a given Currency code
6385: | at the profile option level AND RETURNs the same, IF it doesn't find one
6386: | THEN looks at pn_currencies AND RETURNs Conversion Rate Type.
6387: |
6388: | SCOPE - PUBLIC
6389: |
6390: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 6412: FROM pn_currencies

6408: l_pn_curr_type VARCHAR2(30);
6409:
6410: CURSOR curr_cursor IS
6411: SELECT conversion_type
6412: FROM pn_currencies
6413: WHERE currency_code = p_curr_code;
6414:
6415: BEGIN
6416: