APPS.PAY_CA_PAYROLL_UTILS SQL Statements

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

Line: 32

    13-Sep-2006 ssmukher   115.2            Added the new procedure delete_actionid.

  /*****************************************************************************
   Name      : check_balance_status
   Purpose   : Function should be used to identify whether the balances relevant
               to partcular attribute are valid for use of BRA.
   Arguments : 1. Start Date
               2. Business Group Id
               3. Atttribute Name
   Return    : 'Y' for valid status and 'N' for invalid status of balance
   Notes     : It will used by Canadian Reports to find
               if all the balances related to a report are valid or not
  *****************************************************************************/

  FUNCTION check_balance_status(
              p_start_date        in date,
              p_business_group_id in hr_organization_units.organization_id%type,
              p_attribute_name    in varchar2)
  RETURN VARCHAR2
  IS

     lv_package_stage    VARCHAR2(50) := 'pay_ca_payroll_utils.check_balance_status';

Line: 68

  PROCEDURE delete_actionid(p_payroll_action_id IN NUMBER) IS

   CURSOR c_get_report_type(p_payactid NUMBER) IS
   SELECT
         ppa.report_type
   FROM
         pay_payroll_actions ppa
   WHERE
         ppa.payroll_action_id = p_payactid;

Line: 79

   SELECT
          pfd.file_detail_id
   FROM   pay_file_details pfd
   WHERE  pfd.source_id = p_payactid;

Line: 85

   SELECT
          pfd.file_detail_id
   FROM   pay_file_details pfd
   WHERE  pfd.source_id in (
	  SELECT assignment_action_id
	  FROM   pay_assignment_actions
	  WHERE  payroll_action_id = p_payactid);

Line: 103

       DELETE
       FROM   pay_file_details
       WHERE  file_detail_id = l_file_detid;

Line: 111

                delete from pay_file_details
                where file_detail_id = aalist(i);

Line: 118

/* Calling the core procedure to delete the Payroll actions
   and Assignment actions */
   pay_archive.remove_report_actions(p_payroll_action_id);

Line: 122

END delete_actionid;