APPS.JG_GLOBE_FLEX_VAL dependencies on AR_SYSTEM_PARAMETERS

Line 1784: FROM ar_system_parameters s

1780: --
1781:
1782: CURSOR generate_number IS
1783: SELECT s.generate_customer_number
1784: FROM ar_system_parameters s
1785: WHERE s.set_of_books_id = p_sob_id;
1786: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;
1787:
1788: PG_DEBUG varchar2(1);

Line 1786: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;

1782: CURSOR generate_number IS
1783: SELECT s.generate_customer_number
1784: FROM ar_system_parameters s
1785: WHERE s.set_of_books_id = p_sob_id;
1786: l_cust_man_numbering ar_system_parameters.generate_customer_number%TYPE;
1787:
1788: PG_DEBUG varchar2(1);
1789:
1790: BEGIN

Line 1809: -- Get Customer Numbering - Automatic/Manual from AR_SYSTEM_PARAMETERS

1805: arp_standard.debug('check_attr_value: ' || 'Global Descr Flex Field Validation Begin: '
1806: || to_char(sysdate, 'DD-MON-RR HH:MI:SS'));
1807: END IF;
1808:
1809: -- Get Customer Numbering - Automatic/Manual from AR_SYSTEM_PARAMETERS
1810:
1811: IF p_int_table_name = 'CUSTOMER' THEN
1812: OPEN generate_number;
1813: FETCH generate_number INTO l_cust_man_numbering;