APPS.PAY_NO_EMP_CONT SQL Statements

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

Line: 137

	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: 155

	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: 173

    select ORG_INFORMATION3
    from HR_ORGANIZATION_INFORMATION
    where ORGANIZATION_ID = p_tax_unit_id
    and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';

Line: 181

	select nvl(to_number(ORG_INFORMATION1),0)
	from hr_organization_information
	where ORGANIZATION_ID = p_org_id
	and ORG_INFORMATION_CONTEXT = 'NO_NI_EXEMPTION_LIMIT'
	and p_date_earned between fnd_date.canonical_to_date(ORG_INFORMATION2) and fnd_date.canonical_to_date(ORG_INFORMATION3);

Line: 191

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

Line: 698

												-- insert a new row for exceeded limit

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

Line: 717

												-- finished inserting new row

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

Line: 1286

												-- insert a new row for exceeded limit

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

Line: 1306

												-- finished inserting new row

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

Line: 1408

	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: 1442

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: 1546

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

Line: 1614

	    select  date_of_birth
		into    l_dob
		from     per_all_people_f         pap
		        ,per_all_assignments_f    asg
		        ,pay_assignment_actions   assact
		where  assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
		and    assact.assignment_id = asg.assignment_id
		and    p_date_earned between asg.effective_start_date and asg.effective_end_date
		and    p_date_earned between pap.effective_start_date and pap.effective_end_date
		and    asg.PERSON_ID = pap.PERSON_ID;

Line: 1648

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

Line: 1863

		-- 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: 2059

 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: 2088

       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' ) ;