APPS.PAY_PYEPFREQ_PKG SQL Statements

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

Line: 43

    SELECT 	pay_freq_rule_periods_s.nextval
    INTO	v_freq_rule_pd_id
    FROM	sys.dual;

Line: 47

    INSERT INTO	pay_freq_rule_periods (
	freq_rule_period_id,
	ele_payroll_freq_rule_id,
	business_group_id,
	period_no_in_reset_period,
	creation_date,
	created_by,
	last_update_date,
	last_updated_by,
	last_update_login)
    VALUES (
	v_freq_rule_pd_id,
	p_ele_freqrule_id,
	p_bus_grp_id,
	p_period_no_in_reset_period,
	p_eff_start_date,
	-1,
	NULL,
	NULL,
	NULL);

Line: 85

    SELECT	'Y'
    INTO	v_freq_rule_exists
    FROM	pay_ele_payroll_freq_rules	EPF,
		pay_freq_rule_periods 		FRP
    WHERE	FRP.period_no_in_reset_period	= p_period_num
    AND		FRP.ele_payroll_freq_rule_id	= EPF.ele_payroll_freq_rule_id
    AND 	EPF.business_group_id + 0		= p_bus_grp_id
    AND		EPF.payroll_id			= p_pay_id
    AND		EPF.element_type_id		= p_ele_id;

Line: 106

IF UPPER(p_context) = 'ON-UPDATE' THEN
  v_eff_start_date := nvl(p_eff_date, sysdate);

Line: 121

  SELECT 	ele_payroll_freq_rule_id
  INTO		v_ele_pay_freq_rule_id
  FROM		pay_ele_payroll_freq_rules
  WHERE		element_type_id 	= p_eletype_id
  AND		payroll_id		= p_payroll_id
  AND		business_group_id + 0	= p_bg_id;

Line: 129

  DELETE FROM 	pay_ele_payroll_freq_rules
  WHERE 	ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;

Line: 133

  DELETE FROM 	pay_freq_rule_periods
  WHERE 	ele_payroll_freq_rule_id = v_ele_pay_freq_rule_id;

Line: 154

  SELECT 	number_per_fiscal_year
  INTO		v_number_per_fy
  FROM 		per_time_period_types
  WHERE		period_type 	= p_period_type;

Line: 180

  SELECT 	pay_ele_payroll_freq_rules_s.nextval
  INTO		v_ele_pay_freq_rule_id
  FROM		sys.dual;

Line: 185

  INSERT INTO pay_ele_payroll_freq_rules (
  	  ele_payroll_freq_rule_id,
	  element_type_id,
	  payroll_id,
	  business_group_id,
	  start_date,
	  reset_no_of_periods,
	  reset_period_type,
          rule_date_code,
	  creation_date,
	  created_by,
	  last_update_date,
	  last_updated_by,
	  last_update_login)
  VALUES (
	  v_ele_pay_freq_rule_id,
	  p_eletype_id,
	  p_payroll_id,
	  p_bg_id,
	  v_freq_rule_start_date,
	  v_reset_periods,
	  v_reset_period_type,
          p_rule_date_code,
	  v_eff_start_date,
	  -1,
	  NULL,
	  NULL,
	  NULL
         );

Line: 327

     SELECT  'Y', EPF.rule_date_code
     FROM     pay_ele_payroll_freq_rules      EPF,
              pay_freq_rule_periods           FRP
     WHERE    FRP.period_no_in_reset_period   = cp_period_num
     AND      FRP.ele_payroll_freq_rule_id    = EPF.ele_payroll_freq_rule_id
     AND      EPF.business_group_id + 0       = cp_bg_id
     AND      EPF.payroll_id                  = cp_payroll_id
     AND      EPF.element_type_id             = cp_ele_type_id;

Line: 485

  Purpose   : This procedure will delete the plsql tables used for
              frequency rule data.
  Arguments :
  Notes     :
 */

  procedure initialise_freqrule_table is

  BEGIN

    hr_utility.trace('deleting g_freq_rule_table plsql table');

Line: 497

    pay_pyepfreq_pkg.g_freq_rule_table.delete;