APPS.PAY_CN_REPORT_PKG SQL Statements

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

Line: 39

            SELECT DECODE(p_dimension_name,
	                     'PTD', action_information5,
	                     'YTD', action_information4) value
            FROM   pay_action_information pai
	    WHERE  pai.action_context_id = p_assignment_action_id
	    AND    pai.action_context_type = 'AAP'
	    AND    pai.action_information_category = 'APAC BALANCES'
	    AND    pai.action_information1 = c_balance_name;

Line: 49

         SELECT nvl(pbtl.reporting_name,pbtl.balance_name)
         FROM  pay_balance_types pbt,
               pay_balance_types_tl pbtl
         WHERE pbt.balance_name  = p_balance_name
         AND   pbt.legislation_code = 'CN'
         AND   pbt.balance_type_id = pbtl.balance_type_id
         AND   pbtl.language = userenv('LANG');

Line: 121

            SELECT action_information5 value
            FROM   pay_action_information pai
	    WHERE  pai.action_context_id = p_assignment_action_id
	    AND    pai.action_context_type = 'AAP'
	    AND    pai.action_information_category = 'APAC ELEMENTS'
	    AND    pai.action_information1 = c_element_name
	    AND    pai.action_information7 IS NULL;

Line: 130

         SELECT petl.element_name
         FROM  pay_element_types_f pet,
               pay_element_types_f_tl petl
         WHERE pet.element_name  = p_element_name
         AND   pet.legislation_code = 'CN'
         AND   pet.element_type_id = petl.element_type_id
         AND   petl.language = userenv('LANG');

Line: 203

            SELECT action_information5 value
            FROM   pay_action_information pai
	    WHERE  pai.action_context_id = p_assignment_action_id
	    AND    pai.action_context_type = 'AAP'
	    AND    pai.action_information_category = 'APAC ELEMENTS'
	    AND    pai.action_information1 = c_element_name
	    AND    pai.action_information7 = p_input_value_name;

Line: 212

         SELECT petl.element_name
         FROM pay_element_types_f pet,
              pay_element_types_f_tl petl
         WHERE pet.element_name  = p_element_name
         AND   pet.legislation_code = 'CN'
         AND   pet.element_type_id = petl.element_type_id
         AND   petl.language = userenv('LANG');