APPS.HR_NL_EXTRA_ASG_RULES SQL Statements

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

Line: 53

    SELECT pp.period_type
    FROM   pay_payrolls_f pp
    WHERE  pp.payroll_id=p_payroll_id
    AND    p_effective_date BETWEEN pp.effective_start_date
                            AND     pp.effective_end_date;

Line: 61

    SELECT marital_status
    FROM   per_all_people_f
    WHERE  person_id        = p_person_id
    AND    p_effective_date BETWEEN effective_start_date
                            AND     effective_end_date;

Line: 68

    SELECT UPPER(description)
    FROM   hr_lookups
    WHERE  lookup_type      ='MAR_STATUS'
    AND    lookup_code      = p_lookup_code;

Line: 75

    SELECT scl.segment11 tax_code
           ,scl.segment4  tax_red
           ,scl.segment7  labour_tax
           ,scl.segment9  add_sr_tax
    FROM   per_all_assignments_f            asg
          ,hr_soft_coding_keyflex        scl
    WHERE  asg.assignment_id           = p_assignment_id
    AND    asg.soft_coding_keyflex_id    = scl.soft_coding_keyflex_id
    AND    p_effective_date
    BETWEEN asg.effective_start_date AND     asg.effective_end_date;

Line: 111

		/*Fetch the Db Values for the Assignment if Update_emp_asg
		is being called */

		OPEN csr_get_asg_tax_details(p_assignment_id,p_effective_date);

Line: 202

			-- white tax table only. Please select the white tax table
			-- if the employee is eligible for a labour tax reduction."
			hr_utility.set_message(800, 'HR_NL_LTR_NA_FOR_GREEN_TABLE');

Line: 211

			-- to the green tax table only. Please select the green tax
			-- table if the employee is eligible for an additional
			-- senior tax reduction."
			hr_utility.set_message(800, 'HR_NL_ASTR_NA_FOR_WHITE_TABLE');

Line: 309

    SELECT '1'
    FROM   hr_lookups
    WHERE  lookup_code  = p_lookup_code
    AND    lookup_type   = p_lookup_type;

Line: 318

        SELECT scl.segment10 special_indicator
        FROM   per_all_assignments_f  asg
              ,hr_soft_coding_keyflex scl
        WHERE  asg.assignment_id           = p_assignment_id
        AND    asg.soft_coding_keyflex_id    = scl.soft_coding_keyflex_id
        AND    p_effective_date
        BETWEEN asg.effective_start_date AND     asg.effective_end_date;

Line: 440

    SELECT '1'
    FROM   hr_lookups
    WHERE  lookup_code  = p_lookup_code
    AND    lookup_type   = p_lookup_type;

Line: 451

	SELECT scl.segment2  emp_type
	   ,scl.segment3  emp_sub_type
	   ,scl.segment21 commencing_from
	   ,scl.segment23 date_ending
	FROM   per_all_assignments_f            asg
	  ,hr_soft_coding_keyflex        scl
	WHERE  asg.assignment_id         = p_assignment_id
	AND    asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
	AND    p_effective_date
	BETWEEN asg.effective_start_date AND     asg.effective_end_date;

Line: 492

		/*Fetch the Db Values for the Assignment if Update_emp_asg
		is being called */

		OPEN csr_get_asg_oth_details(p_assignment_id,p_effective_date);

Line: 832

	SELECT scl.segment21 commencing_date
	,scl.segment23 date_ending
	FROM   per_all_assignments_f         asg
	,hr_soft_coding_keyflex        scl
	WHERE  asg.assignment_id           = p_assignment_id
	AND    asg.soft_coding_keyflex_id    = scl.soft_coding_keyflex_id
	AND    p_effective_date
	BETWEEN asg.effective_start_date AND     asg.effective_end_date;

Line: 844

	select payroll_id,person_id
	from per_all_assignments_f PAA
	where assignment_id=p_assignment_id and
	p_effective_date between PAA.effective_start_date and PAA.effective_end_date;

Line: 850

	select frequency
	from per_all_assignments_f PAA
	where assignment_id=p_assignment_id and
	p_effective_date between PAA.effective_start_date and PAA.effective_end_date;