APPS.HR_JPDRB SQL Statements

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

Line: 45

	SELECT	TO_NUMBER(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
	FROM	pay_payroll_actions	ppa,
		pay_assignment_actions	paa
	WHERE	paa.assignment_id = p_assignment_id
	AND	ppa.payroll_action_id = paa.payroll_action_id
	AND	ppa.effective_date <= p_effective_date
	AND	ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line: 55

    	SELECT	TO_NUMBER(substr(max(lpad(ASSACT.action_sequence,15,'0')||ASSACT.assignment_action_id),16))
	FROM	pay_payroll_actions    PACT,
		pay_assignment_actions ASSACT
	WHERE	ASSACT.assignment_id = p_assignment_id
	AND	PACT.payroll_action_id = ASSACT.payroll_action_id
	AND	PACT.date_earned <= p_effective_date
	AND	PACT.action_type in ('R', 'Q', 'I', 'V', 'B');

Line: 65

        SELECT	RTRIM(SUBSTRB(DIM.dimension_name,31,15),' ')
        FROM	pay_balance_dimensions  DIM,
        	pay_defined_balances    DB
        WHERE   DB.defined_balance_id = p_defined_balance_id
        AND     DIM.balance_dimension_id = DB.balance_dimension_id;

Line: 170

	SELECT	pbd.dimension_name
	FROM	pay_balance_dimensions	pbd,
		pay_defined_balances	pdb
	WHERE	pdb.defined_balance_id = c_defined_balance_id
	AND	pbd.balance_dimension_id = pdb.balance_dimension_id;

Line: 178

	SELECT	PACT.business_group_id,
		PACT.date_earned
	FROM	pay_payroll_actions	PACT,
		pay_assignment_actions	ASSACT
	WHERE	ASSACT.assignment_action_id = p_assignment_action_id
	AND	PACT.payroll_action_id = ASSACT.payroll_action_id;

Line: 291

	SELECT	ptp.end_date
	FROM	per_time_periods	ptp,
		pay_payroll_actions	ppa,
		pay_assignment_actions	paa
	WHERE	paa.assignment_action_id = c_assignment_action_id
	AND	ppa.payroll_action_id = paa.payroll_action_id
	AND	ptp.time_period_id = ppa.time_period_id;

Line: 320

	SELECT	ppa.effective_date
	FROM	pay_payroll_actions	ppa,
		pay_assignment_actions	paa
	WHERE	paa.assignment_action_id = p_assignment_action_id
	AND	paa.payroll_action_id = ppa.payroll_action_id;