APPS.PER_ES_ADDRESS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

PROCEDURE update_es_address (p_address_id   IN NUMBER
                            ,p_postal_code  IN VARCHAR2
                            ,p_region_2     IN VARCHAR2) IS
    --
    CURSOR csr_get_address_info(c_address_id number) is
    SELECT style,  postal_code, region_2
    FROM   per_addresses
    WHERE  address_id=c_address_id;

Line: 93

END update_es_address;

Line: 95

PROCEDURE update_es_address_style(p_address_id   IN NUMBER
                                 ,p_postal_code  IN VARCHAR2
                                 ,p_region_2     IN VARCHAR2
                                 ,p_style        IN VARCHAR2) IS
    --
    CURSOR csr_get_address_info(c_address_id number) is
    SELECT postal_code, region_2
    FROM   per_addresses
    WHERE  address_id=c_address_id;

Line: 142

END update_es_address_style;