APPS.PAY_NO_EMP_CONT_2007 SQL Statements

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

Line: 129

	select pact.ASSIGNMENT_ACTION_ID
	from pay_assignment_actions pact
	    ,pay_run_types_f		prt
	where pact.PAYROLL_ACTION_ID = p_payroll_action_id
	and   pact.TAX_UNIT_ID = p_tax_unit_id
	and   prt.LEGISLATION_CODE = 'NO'
	and   prt.RUN_TYPE_NAME = 'Employer Contributions'
	and   nvl(pact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID
	and   p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE ;

Line: 147

	select count(*)
	from pay_assignment_actions pact
	    ,pay_run_types_f		prt
	where pact.PAYROLL_ACTION_ID = p_payroll_action_id
	and   pact.TAX_UNIT_ID = p_tax_unit_id
	and   prt.LEGISLATION_CODE = 'NO'
	and   prt.RUN_TYPE_NAME = 'Employer Contributions'
	and   nvl(pact.RUN_TYPE_ID,-99) <> prt.RUN_TYPE_ID
	and   p_date_earned between prt.EFFECTIVE_START_DATE and prt.EFFECTIVE_END_DATE ;

Line: 160

    select last_day(Add_months(p_date_earned,MOD(TO_NUMBER(TO_CHAR(p_date_earned,'MM')),2)))
    from dual;

Line: 619

												-- insert a new row for exceeded limit

											        g_tab_calc(8).zone 				:= g_tab_calc(i).zone;

Line: 630

												-- finished inserting new row

												-- set remaining rows under_limit = N
												FOR j IN i+1..7 LOOP
													g_tab_calc(j).under_limit := 'N';

Line: 1158

												-- insert a new row for exceeded limit

												g_tab_calc(8).zone 				:= g_tab_calc(i).zone;

Line: 1169

												-- finished inserting new row

												-- set remaining rows under_limit = N
												FOR j IN i+1..7 LOOP
													g_tab_calc(j).under_limit := 'N';

Line: 1275

	SELECT pdb.defined_balance_id
	INTO   l_defined_balance_id
	FROM   pay_defined_balances      pdb
	      ,pay_balance_types         pbt
	      ,pay_balance_dimensions    pbd
	WHERE  pbd.database_item_suffix = p_dbi_suffix
	AND    pbd.legislation_code = 'NO'
	AND    pbt.balance_name = p_balance_name
	AND    pbt.legislation_code = 'NO'
	AND    pdb.balance_type_id = pbt.balance_type_id
	AND    pdb.balance_dimension_id = pbd.balance_dimension_id
	AND    pdb.legislation_code = 'NO';

Line: 1309

SELECT ELEMENT_TYPE_ID
FROM pay_element_types_f      pet
WHERE pet.element_name = 'Tax Deduction Base'
AND   pet.LEGISLATION_CODE = 'NO'
AND   p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;

Line: 1319

SELECT ELEMENT_TYPE_ID
FROM pay_element_types_f      pet
WHERE pet.element_name = 'Tax'
AND   pet.LEGISLATION_CODE = 'NO'
AND   p_date_earned BETWEEN pet.EFFECTIVE_START_DATE AND pet.EFFECTIVE_END_DATE ;

Line: 1418

								END IF; -- end IF for inserting Local Unit in l_unique_lu_tab table

Line: 1478

    select meaning
    from   hr_lookups
    where  lookup_type  = p_lookup_type
    and    lookup_code  = p_lookup_code
    and    enabled_flag = 'Y';

Line: 1681

		-- inserting values in g_tab_main
		g_tab_main(l_curr_index).run_base 		:= g_tab_main(l_curr_index).run_base + g_tab_calc(i).run_base ;

Line: 1864

 select pucf.EFFECTIVE_START_DATE
		,pucf.EFFECTIVE_END_DATE
		,pucf.VALUE
from pay_user_tables	put
	,pay_user_rows_f	pur
	,pay_user_columns	puc
	,pay_user_column_instances_f	pucf
where	put.USER_TABLE_NAME = 'NO_GLOBAL_CONSTANTS'
and 	pur.ROW_LOW_RANGE_OR_NAME = 'NATIONAL_INSURANCE_BASE_RATE'
and 	puc.USER_COLUMN_NAME = 'Value'
and 	put.legislation_code = 'NO'
and 	pur.legislation_code = 'NO'
and 	puc.legislation_code = 'NO'
and 	( pucf.business_group_id = p_bus_grp_id OR pucf.business_group_id is NULL )
and 	put.user_table_id = pur.user_table_id
and 	put.user_table_id = puc.user_table_id
and		pucf.user_row_id = pur.user_row_id
and 	pucf.user_column_id = puc.user_column_id
and		p_date_earned between pur.effective_start_date and pur.effective_end_date
and     pucf.effective_start_date < (trunc(add_months(p_date_earned,12),'Y')-1)
and     pucf.effective_end_date > trunc(p_date_earned , 'Y' ) ;

Line: 1894

       select  EFFECTIVE_START_DATE
             , EFFECTIVE_END_DATE
             , to_number(global_value) VALUE
       from ff_globals_f
       where legislation_code = 'NO'
       and   global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
       and   BUSINESS_GROUP_ID IS NULL
       and   effective_start_date  <= (trunc(add_months(p_date_earned,12),'Y')-1)
       and   effective_end_date    >= trunc(p_date_earned , 'Y' ) ;

Line: 1906

       select  EFFECTIVE_START_DATE
             , EFFECTIVE_END_DATE
             , fnd_number.canonical_to_number(global_value) VALUE
       from ff_globals_f
       where legislation_code = 'NO'
       and   global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
       and   BUSINESS_GROUP_ID IS NULL
       and   effective_start_date  <= (trunc(add_months(p_date_earned,12),'Y')-1)
       and   effective_end_date    >= trunc(p_date_earned , 'Y' ) ;