eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_PAYTRN SQL Statements

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

Line: 33


SELECT	start_date, end_date, payroll_id
FROM	per_time_periods
WHERE	time_period_id = p_time_period_id ;

Line: 45


SELECT	distinct(gl_set_of_books_id),business_group_id
FROM	pay_payrolls_f
WHERE	payroll_id = l_payroll_id and
	((l_start_date between effective_start_date and effective_end_date) or
	(l_end_date	between effective_start_date and effective_end_date) or
	(l_start_date <= effective_start_date and l_end_date >= effective_end_date))
	and gl_set_of_books_id is not null;

Line: 59


SELECT	distinct(gl_set_of_books_id)
FROM	pay_payroll_gl_flex_maps
WHERE	payroll_id = l_payroll_id;

Line: 95


select nvl(parameter_value, 'P') parameter_value
from PAY_ACTION_PARAMETER_VALUES
where parameter_name = 'TGL_DATE_USED'
and action_parameter_group_id = l_action_parameter_group;

Line: 101


select nvl(parameter_value, 'P') parameter_value
from PAY_ACTION_PARAMETER_VALUES
where parameter_name = 'TGL_REVB_ACC_DATE'
and action_parameter_group_id = l_action_parameter_group;

Line: 106


/* to select all costed record for quickpay/ regular pay for a particular timeperiod . This would replace both the
get payroll actions cursor and get assignment actions cursor

*/
 CURSOR get_payroll_assig_actions_csr is
 select paa2.assignment_id, paa2.assignment_action_id ,
 	ppa2.payroll_id, ppa2.payroll_action_id, ppa1.effective_date,
 	ppa1.date_earned, ppa2.time_period_id,
 	ppa2.pay_advice_date ,
 	decode(ppa1.action_type,'V',decode(l_TGL_REVB_ACC_DATE,'C',ppa2.effective_date,
 						ppa1.effective_date),
 		decode(l_TGL_DATE_USED,'E',ppa1.date_earned,
 						ppa1.effective_date)) accounting_date
  from pay_payroll_actions ppa1, pay_assignment_actions paa1,
 	pay_payroll_actions ppa2,
 	pay_assignment_actions paa2
  where ppa1.payroll_id= l_payroll_id
 	--and ppa1.date_earned    --13931157
	and decode(ppa1.action_type,'R',ppa1.date_earned,'Q',ppa1.date_earned,'V',ppa1.effective_date) --13931157
	between l_start_date and l_end_date
 	and ppa1.action_type IN ('R','Q','V') -- regular run, quick_pay, reversals
 	and ppa1.payroll_action_id = paa1.payroll_action_id
 	and EXISTS	(SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
 		FROM	pay_action_interlocks pai1
 		WHERE	paa1.assignment_action_id = pai1.locked_action_id
 			and pai1.locking_action_id = paa2.assignment_action_id)	-- End of changes for bug fix 3263333
 	and paa2.payroll_action_id = ppa2.payroll_action_id
 	and ppa2.action_type = 'C'
 	and ppa2.action_status='C'
 and exists (select assignment_action_id from pay_costs where
 assignment_action_id=paa2.assignment_action_id)
 UNION
 -- broke the decode for bug 6409008
 /* Now for 'B'*/
 (select paa1.assignment_id, paa1.assignment_action_id,
 	ppa1.payroll_id, ppa1.payroll_action_id, ppa1.effective_date, ppa1.date_earned,
 	ppa1.time_period_id, ppa1.pay_advice_date ,
 	decode(ppa2.action_type,'B',decode(l_TGL_REVB_ACC_DATE,'C',ppa1.effective_date,
 						ppa2.effective_date),
 		decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
 						ppa2.effective_date)) accounting_date
  from pay_payroll_actions ppa1, pay_assignment_actions paa1,
 	pay_payroll_actions ppa2,
 	pay_assignment_actions paa2
 where   ppa2.action_type = 'B'
         and ppa2.date_earned between l_start_date and l_end_date
 	and ppa2.payroll_id=l_payroll_id
 	and ppa1.action_type='C' and
 	ppa1.action_status='C'
 	and ppa1.payroll_action_id=paa1.payroll_action_id
 	and EXISTS	(SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
 			FROM	pay_action_interlocks pai1
 			WHERE	paa1.assignment_action_id=pai1.locking_action_id
 				and pai1.locked_action_id = paa2.assignment_action_id)	-- End of changes for bug fix 3263333
 	and paa2.payroll_action_id = ppa2.payroll_action_id
 	and ppa2.action_type not in ('R','Q' ,'F','V')
 and exists
 (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))
 UNION
 /* Now for '0' etc: */
 (select paa1.assignment_id, paa1.assignment_action_id,
 	ppa1.payroll_id, ppa1.payroll_action_id, ppa1.effective_date, ppa1.date_earned,
 	ppa1.time_period_id, ppa1.pay_advice_date ,
 	decode(ppa2.action_type,'B',decode(l_TGL_REVB_ACC_DATE,'C',ppa1.effective_date,
 						ppa2.effective_date),
 		decode(l_TGL_DATE_USED,'E',ppa2.date_earned,
 						ppa2.effective_date)) accounting_date
  from pay_payroll_actions ppa1, pay_assignment_actions paa1,
 	pay_payroll_actions ppa2,
 	pay_assignment_actions paa2
  where  ppa2.action_type <> 'B'
         and ppa1.effective_date between l_start_date and l_end_date
 	and ppa2.payroll_id=l_payroll_id
 	and ppa1.action_type='C' and
 	ppa1.action_status='C'
 	and ppa1.payroll_action_id=paa1.payroll_action_id
 	and EXISTS	(SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
 			FROM	pay_action_interlocks pai1
 			WHERE	paa1.assignment_action_id=pai1.locking_action_id
 				and pai1.locked_action_id = paa2.assignment_action_id)	-- End of changes for bug fix 3263333
 	and paa2.payroll_action_id = ppa2.payroll_action_id
 	and ppa2.action_type not in ('R','Q' ,'F','V')
 and exists
 (select assignment_action_id from pay_costs where assignment_action_id=paa1.assignment_action_id))
 order by 9 desc, 7 desc, 2 desc;   -- Bug 7116131;

Line: 210


SELECT payroll_id,
	payroll_action_id,
	effective_date,
	date_earned,
	time_period_id,
	pay_advice_date
FROM	PAY_PAYROLL_ACTIONS
WHERE	effective_date between l_start_date and l_end_date and
	payroll_id = l_payroll_id and
	action_type in ('R','Q') and action_status = 'C';

Line: 233


SELECT a.assignment_id,
	a.assignment_action_id,
	b.person_id
FROM	PAY_ASSIGNMENT_ACTIONS a,
	PER_ASSIGNMENTS_F b
WHERE	a.payroll_action_id = g_payroll_rec.payroll_action_id
	and a.action_status = 'C'
	and (a.assignment_id = b.assignment_id and
	((l_start_date between effective_start_date and effective_end_date) or
	(l_end_date	between effective_start_date and effective_end_date) or
	(l_start_date <= effective_start_date and l_end_date >= effective_end_date)))
	and a.assignment_action_id in (select distinct(assignment_action_id) from pay_costs)
	order by a.assignment_id;

Line: 250


 restriction on assignment_action id in selecting only those employees for whom arecord exists in pay_costs table:-
 fixed by Subha, :- Caltech
*/
--Declare variables for above cursor

l_assignment_id		PAY_ASSIGNMENT_ACTIONS.ASSIGNMENT_ID%TYPE;

Line: 262


SELECT	a.cost_id,		--- REgular run results
	a.costed_value,
	a.debit_or_credit,
	a.balance_or_cost,
	a.cost_allocation_keyflex_id,
	b.element_type_id,
	DECODE(piv.uom, 'M', d.output_currency_code, 'STAT') output_currency_code,
	b.start_date,
	b.end_date,
	paya.date_earned,
	paya.action_type action_type,
	ptp.start_date tp_start_date,
	ptp.end_date tp_end_date,
	ptp.time_period_id,
	NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
FROM	PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
	pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
	pay_input_values_f piv
WHERE	a.assignment_action_id	= l_assignment_action_id and
	SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
	not exists ( select null
			from pay_element_entries_f pee
			where pee.element_entry_id = b.source_id and
				pee.creator_type in ('RR','EE')) and
	a.balance_or_cost = 'C' and
	NVL(a.costed_value,0) <> 0 and
	a.run_result_id = b.run_result_id and
	a.input_value_id = piv.input_value_id and
	c.business_group_id = l_resp_business_group_id and
	c.set_of_books_id = l_resp_set_of_books_id and
	( b.element_type_id = c.element_type_id and
	(c.start_date_active between l_start_date and l_end_date or
	nvl( c.end_date_active,to_date('4712/12/31' , 'YYYY/MM/DD'))	between l_start_date and l_end_date or
	(c.start_date_active <= l_start_date
	and nvl(c.end_date_active, to_date('4712/12/31' , 'YYYY/MM/DD')) >= l_end_date))) and
	b.element_type_id = d.element_type_id and
	(g_payroll_asg_rec.effective_date between d.effective_start_date and d.effective_end_date)
	and b.assignment_action_id = asga.assignment_action_id
	and paya.payroll_action_id = asga.payroll_action_id
	and ptp.payroll_id = l_payroll_id
	and paya.date_earned between ptp.start_date and ptp.end_date
union all
SELECT	a.cost_id,	--- retro run results
	a.costed_value,
	a.debit_or_credit,
	a.balance_or_cost,
	a.cost_allocation_keyflex_id,
	b.element_type_id,
	DECODE(piv.uom, 'M', d.output_currency_code, 'STAT') output_currency_code,
	b.start_date,
	b.end_date,
	paya.date_earned,
	'L' action_type,	---- retro
	ptp.start_date tp_start_date,
	ptp.end_date tp_end_date,
	ptp.time_period_id,
	NVL(b.element_entry_id, (SELECT element_entry_id FROM pay_run_results prr where prr.run_result_id = b.source_id)) source_id
FROM	PAY_COSTS a, PAY_RUN_RESULTS b, PSP_ELEMENT_TYPES c, PAY_ELEMENT_TYPES_F d,
	pay_assignment_actions asga, pay_payroll_actions paya, per_time_periods ptp,
	pay_input_values_f piv
WHERE	a.assignment_action_id	= l_assignment_action_id and
	SUBSTR(piv.uom, 1, 1) IN ('M', g_uom) AND
	exists ( select null
			from pay_element_entries_f pee
		where pee.element_entry_id = b.source_id and
				pee.creator_type in ('RR','EE')) and
	a.balance_or_cost = 'C' and
	NVL(a.costed_value,0) <> 0 and
	a.run_result_id = b.run_result_id and
	a.input_value_id = piv.input_value_id and
	c.business_group_id = l_resp_business_group_id and
	c.set_of_books_id = l_resp_set_of_books_id and
	( b.element_type_id = c.element_type_id and
	(c.start_date_active between l_start_date and l_end_date or
	nvl( c.end_date_active,to_date('4712/12/31' , 'YYYY/MM/DD'))	between l_start_date and l_end_date or
	(c.start_date_active <= l_start_date
	and nvl(c.end_date_active, to_date('4712/12/31' , 'YYYY/MM/DD')) >= l_end_date))) and
	b.element_type_id = d.element_type_id and
	(g_payroll_asg_rec.effective_date between d.effective_start_date and d.effective_end_date)
	and b.assignment_action_id = asga.assignment_action_id
	and paya.payroll_action_id = asga.payroll_action_id
	and ptp.payroll_id = l_payroll_id
	and b.end_date between ptp.start_date and ptp.end_date
order by time_period_id desc , 15 asc;

Line: 350


SELECT cost_id
FROM	PSP_PAYROLL_LINES
WHERE	cost_id = g_pay_costs_rec.cost_id;

Line: 360


SELECT sum(pay_amount)
FROM	psp_payroll_sub_lines
WHERE	payroll_line_id = l_line_id;

Line: 367


SELECT reversing_gl_ccid
FROM	psp_clearing_account
where set_of_books_id=l_resp_set_of_books_id
and business_group_id=l_resp_business_group_id
and payroll_id = l_payroll_id; -- Added for bug 5592964

Line: 421


SELECT	pcv_information1
FROM	pqp_configuration_values pcv
WHERE	pcv.business_group_id = l_resp_business_group_id
AND	pcv_information_category = 'PSP_PRORATION';

Line: 428


SELECT	legislation_code
FROM	per_business_groups
WHERE	business_group_id = l_resp_business_group_id;

Line: 468


SELECT	currency_code
FROM	gl_sets_of_books gsob
WHERE	set_of_books_id = l_resp_set_of_books_id;

Line: 474


 select cnt_asg,
	fvl.meaning action_name,
	ptp.period_name,
	parent_payroll_control_id
	from (select count(distinct ppl.assignment_id) cnt_asg,
		ppl.payroll_action_type,
		ppc.time_period_id,
		ppc.parent_payroll_control_id
		from psp_payroll_controls ppc,
		psp_payroll_lines ppl
		where ppc.run_id = l_run_id
		and ppc.payroll_control_id = ppl.payroll_control_id
		group by ppl.payroll_action_type, ppc.time_period_id, ppc.parent_payroll_control_id) kount,
	fnd_lookup_values_vl fvl,
	per_time_periods ptp
 where kount.payroll_action_type = fvl.lookup_code
	and fvl.lookup_type = 'ACTION_TYPE'
	and sysdate between nvl(fvl.start_date_active,fnd_date.canonical_to_date('2000/01/31')) and nvl(fvl.end_date_active, fnd_date.canonical_to_date('4000/01/31'))
	and kount.time_period_id = ptp.time_period_id
	order by parent_payroll_control_id desc, ptp.time_period_id asc;

Line: 496


	select message_text
	from fnd_new_messages
	where application_id = 8403
	and message_name = 'PSP_IMP_INDICATE_MASTER'
	and language_code = userenv('LANG');

Line: 502


 select meaning
	from fnd_lookup_values_vl
	where lookup_code in ('LABEL1_IMP_SUM', 'LABEL2_IMP_SUM', 'LABEL3_IMP_SUM', 'LABEL4_IMP_SUM')
	and lookup_type = 'PSP_MESSAGE_TEXT'
	and sysdate between start_date_active and nvl(end_date_active, fnd_date.canonical_to_date('4000/01/31'))
order by lookup_code;

Line: 516


SELECT	effective_start_date, effective_end_date,date_earned  --LD Dev
FROM	pay_element_entries_f
WHERE	element_entry_id = g_pay_costs_rec.source_id;

Line: 521


SELECT	DECODE(pcv_information1, 'Y', 'H', 'M') employee_hours
FROM	pqp_configuration_values
WHERE	pcv_information_category = 'PSP_IMPORT_EMPLOYEE_HOURS'
AND	legislation_code IS NULL
AND	NVL(business_group_id, p_business_group_id) = p_business_group_id;

Line: 528


SELECT	pcv_information1,
	pcv_information2,
	pcv_information3,
	pcv_information4,
	pcv_information5,
	pcv_information6
FROM	pqp_configuration_values
WHERE	pcv_information_category = 'PSP_ELEMENT_ENTRY_CI_MAPPING'
AND	legislation_code IS NULL
AND	NVL(business_group_id, p_business_group_id) = p_business_group_id;

Line: 545


SELECT	nvl(pcv_information1,'Y')    --6779790
FROM	pqp_configuration_values
WHERE	pcv_information_category = 'PSP_USE_DATE_EARNED'
AND	legislation_code IS NULL
AND	NVL(business_group_id, p_business_group_id) = p_business_group_id;   -- Bug 6046087

Line: 573


SELECT	name
FROM	hr_all_organization_units hou
WHERE	organization_id = l_or_expenditure_org_id;

Line: 578


SELECT	segment1
FROM	pa_projects_all
WHERE	project_id = l_or_project_id;

Line: 583


SELECT	org_id
FROM	pa_projects_all
WHERE	project_id = l_or_project_id;

Line: 588


SELECT	task_number
FROM	pa_tasks_expend_v  -- Bug : 16391366   (20/03/2013)
WHERE	task_id = l_or_task_id;

Line: 593


SELECT	award_number
FROM	gms_awards_all
WHERE	award_id = l_or_award_id;

Line: 598


SELECT	expenditure_type
FROM	pa_expenditure_types
WHERE	expenditure_type = l_or_expenditure_type;

Line: 814


 SELECT psp_st_run_id_s.nextval
 INTO l_run_id
 FROM dual;

Line: 840


		SELECT	DISTINCT person_id
		INTO	l_person_id
		FROM	per_all_assignments_f
		WHERE	assignment_id = l_assignment_id;

Line: 967


					EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
						l_tk_column || ', ' || l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
						' FROM	pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
						' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
					INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
					USING g_pay_costs_rec.date_earned;

Line: 979


					EXECUTE IMMEDIATE 'SELECT ' || l_gl_column || ', ' || l_pt_column || ', ' ||
						l_tk_column || ', ' || l_eo_column || ', ' || l_et_column ||
						' FROM	pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
						' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
					INTO l_or_gl_ccid, l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
					USING g_pay_costs_rec.date_earned;

Line: 992


				EXECUTE IMMEDIATE 'SELECT ' || l_gl_column ||
				' FROM	pay_element_entries_f WHERE element_entry_id = ' || g_pay_costs_rec.source_id ||
				' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
				INTO l_or_gl_ccid
				USING g_pay_costs_rec.date_earned;

Line: 1004


					EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
						l_aw_column || ', ' || l_eo_column || ', ' || l_et_column ||
						' FROM	pay_element_entries_f WHERE element_entry_id = ' ||
						g_pay_costs_rec.source_id ||
						' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
					INTO l_or_project_id, l_or_task_id, l_or_award_id, l_or_expenditure_org_id, l_or_expenditure_type
					USING g_pay_costs_rec.date_earned;

Line: 1017


					EXECUTE IMMEDIATE 'SELECT ' || l_pt_column || ', ' || l_tk_column || ', ' ||
						l_eo_column || ', ' || l_et_column ||
						' FROM	pay_element_entries_f WHERE element_entry_id = ' ||
						g_pay_costs_rec.source_id ||
						' AND :g_date_earned BETWEEN effective_start_date AND effective_end_date'
					INTO l_or_project_id, l_or_task_id, l_or_expenditure_org_id, l_or_expenditure_type
					USING g_pay_costs_rec.date_earned;

Line: 1035


				SELECT	full_name
				INTO	l_employee_name
				FROM	per_people_f
				WHERE	person_id = l_person_id
				AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1055


				SELECT	full_name
				INTO	l_employee_name
				FROM	per_people_f
				WHERE	person_id = l_person_id
				AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1075


				SELECT	full_name
				INTO	l_employee_name
				FROM	per_people_f
				WHERE	person_id = l_person_id
				AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1095


				SELECT	full_name
				INTO	l_employee_name
				FROM	per_people_f
				WHERE	person_id = l_person_id
				AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1116


					SELECT	full_name
					INTO	l_employee_name
					FROM	per_people_f
					WHERE	person_id = l_person_id
					AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1137


				SELECT	full_name
				INTO	l_employee_name
				FROM	per_people_f
				WHERE	person_id = l_person_id
				AND	g_pay_costs_rec.date_earned BETWEEN effective_start_date AND effective_end_date;

Line: 1176


	-- it updates the array rows with 'N' for the rows after the assignment end date.

		hr_utility.trace('	UPDATE_WCAL_ASG_END_DATE');

Line: 1179


		UPDATE_WCAL_ASG_END_DATE(X_ASSIGNMENT_ID	=> l_assignment_id,
					X_RETURN_STATUS	=> l_return_status);

Line: 1182


		l_error_api_name	:= 'UPDATE_WCAL_ASG_END_DATE : ';

Line: 1186


		hr_utility.trace('	UPDATE_WCAL_ASG_BEGIN_DATE');

Line: 1187


		UPDATE_WCAL_ASG_BEGIN_DATE(X_ASSIGNMENT_ID	=> l_assignment_id,
					X_RETURN_STATUS	=> l_return_status);

Line: 1190


		l_error_api_name	:= 'UPDATE_WCAL_ASG_BEGIN_DATE : ';

Line: 1198


		hr_utility.trace('	UPDATE_WCAL_ASG_STATUS');

Line: 1199


		UPDATE_WCAL_ASG_STATUS(X_ASSIGNMENT_ID	=> l_assignment_id,
					X_RETURN_STATUS	=> l_return_status);

Line: 1202


		l_error_api_name	:= 'UPDATE_WCAL_ASG_STATUS : ';

Line: 1205


		hr_utility.trace('	AFTER UPDATE_WCAL_ASG_STATUS');

Line: 1264


		-- If first record insert a record in psp_payroll_controls


	hr_utility.trace('	l_counter = '||l_counter);

Line: 1315


		SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
			FROM DUAL;

Line: 1340


			PSP_PAYROLL_CONTROLS_PKG.INSERT_ROW(
				X_ROWID		=>	x_rowid,
				X_PAYROLL_CONTROL_ID	=>	l_export_id,
				X_PAYROLL_ACTION_ID	=>	g_payroll_asg_rec.payroll_action_id,
				X_PAYROLL_SOURCE_CODE	=>	l_payroll_source,
					X_SOURCE_TYPE		=>	'O',
				X_PAYROLL_ID		=>	l_payroll_id,
				X_TIME_PERIOD_ID	=> g_pay_costs_rec.time_period_id,
				X_BATCH_NAME		=>	NULL,
				X_NUMBER_OF_CR		=>	0,
				X_NUMBER_OF_DR		=>	0,
				X_TOTAL_DR_AMOUNT	=>	0,
				X_TOTAL_CR_AMOUNT	=>	0,
				X_SUBLINES_DR_AMOUNT	=>	NULL,
				X_SUBLINES_CR_AMOUNT	=>	NULL,
				X_DIST_CR_AMOUNT	=>	NULL,
				X_DIST_DR_AMOUNT	=>	NULL,
				X_OGM_DR_AMOUNT		=>	NULL,
				X_OGM_CR_AMOUNT		=>	NULL,
				X_GL_DR_AMOUNT		=>	NULL,
				X_GL_CR_AMOUNT		=>	NULL,
				X_STATUS_CODE		=>	l_status_code,
				X_MODE				=>	'R' ,
				X_GL_POSTING_OVERRIDE_DATE => NULL,
				X_GMS_POSTING_OVERRIDE_DATE => NULL,
				X_SET_OF_BOOKS_ID		=>l_resp_set_of_books_id,
				X_BUSINESS_GROUP_ID	=> l_resp_business_group_id ,
				X_GL_PHASE		=> NULL,
				X_GMS_PHASE		=> NULL,
				X_ADJ_SUM_BATCH_NAME	=> NULL,
--	Introduced the following for bug fix 2916848
				x_currency_code		=>	g_pay_costs_rec.output_currency_code,
				x_exchange_rate_type	=>	null,
				x_parent_payroll_control_id	=> l_parent_control_id);	--- exch rate =null for 3108109

Line: 1380


			update psp_payroll_controls
			set run_id = l_run_id
			where payroll_control_id = l_export_id;

Line: 1415


		SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
		FROM DUAL;

Line: 1440


	select distinct substr(full_name,1,50)
	into l_employee_name
	from per_people_f
	where person_id = l_person_id and
		g_pay_costs_rec.date_earned between effective_start_date and effective_end_date;

Line: 1469


	PSP_PAYROLL_LINES_PKG.INSERT_ROW (
			X_ROWID			=> x_rowid,
			X_PAYROLL_LINE_ID		=> l_line_id ,
			X_PAYROLL_CONTROL_ID		=> l_export_id ,
			X_SET_OF_BOOKS_ID		=> l_resp_set_of_books_id ,
			X_ASSIGNMENT_ID		=> l_assignment_id ,
			X_PERSON_ID			=> l_person_id ,
			X_COST_ID			=> g_pay_costs_rec.cost_id,
			X_ELEMENT_TYPE_ID		=> g_pay_costs_rec.element_type_id,
			X_PAY_AMOUNT			=> g_pay_costs_rec.costed_value ,
			X_STATUS_CODE			=> l_status_code ,
			X_EFFECTIVE_DATE		=> g_payroll_asg_rec.accounting_date,
			X_ACCOUNTING_DATE		=> g_payroll_asg_rec.accounting_date, --added for
			X_EXCHANGE_RATE_TYPE		=> l_exchange_rate_type,		-- 3108109
			X_CHECK_DATE			=> g_payroll_asg_rec.pay_advice_date,
			X_EARNED_DATE			=> g_pay_costs_rec.date_earned,
			X_COST_ALLOCATION_KEYFLEX_ID	=> g_pay_costs_rec.cost_allocation_keyflex_id,
			X_GL_CODE_COMBINATION_ID	=> l_gl_ccid,
			X_BALANCE_AMOUNT		=> l_balance_amount,
			X_DR_CR_FLAG			=> g_pay_costs_rec.debit_or_credit,
			X_MODE			=> 'R',
			X_PAYROLL_ACTION_TYPE		=> g_pay_costs_rec.action_type,
			X_OR_GL_CODE_COMBINATION_ID	=> l_or_gl_ccid,
			X_OR_PROJECT_ID			=> l_or_project_id,
			X_OR_TASK_ID			=> l_or_task_id,
			X_OR_AWARD_ID			=> l_or_award_id,
			X_OR_EXPENDITURE_ORG_ID		=> l_or_expenditure_org_id,
			X_OR_EXPENDITURE_TYPE		=> l_or_expenditure_type);

Line: 1543


		PSP_PAYROLL_LINES_PKG.INSERT_ROW (
			X_ROWID			=> x_rowid,
			X_PAYROLL_LINE_ID		=> l_line_id ,
			X_PAYROLL_CONTROL_ID		=> l_export_id ,
			X_SET_OF_BOOKS_ID		=> l_resp_set_of_books_id ,
			X_ASSIGNMENT_ID		=> l_assignment_id ,
			X_PERSON_ID			=> l_person_id ,
			X_COST_ID			=> g_pay_costs_rec.cost_id,
			X_ELEMENT_TYPE_ID		=> g_pay_costs_rec.element_type_id,
			X_PAY_AMOUNT			=> g_pay_costs_rec.costed_value ,
			X_STATUS_CODE		=> l_status_code ,
			X_EFFECTIVE_DATE		=> g_payroll_asg_rec.effective_date,
			X_ACCOUNTING_DATE		=> g_payroll_asg_rec.accounting_date, --added for
			X_EXCHANGE_RATE_TYPE		=> l_exchange_rate_type,		-- 3108109
			X_CHECK_DATE			=> g_payroll_asg_rec.pay_advice_date,
			X_EARNED_DATE		=> g_pay_costs_rec.date_earned,
			X_COST_ALLOCATION_KEYFLEX_ID	=> g_pay_costs_rec.cost_allocation_keyflex_id,
			X_GL_CODE_COMBINATION_ID	=> l_gl_ccid,
			X_BALANCE_AMOUNT		=> l_balance_amount,
			X_DR_CR_FLAG			=> g_pay_costs_rec.debit_or_credit,
			X_MODE			=> 'R',
			X_PAYROLL_ACTION_TYPE		=> g_pay_costs_rec.action_type,
			X_OR_GL_CODE_COMBINATION_ID	=> l_or_gl_ccid,
			X_OR_PROJECT_ID			=> l_or_project_id,
			X_OR_TASK_ID			=> l_or_task_id,
			X_OR_AWARD_ID			=> l_or_award_id,
			X_OR_EXPENDITURE_ORG_ID		=> l_or_expenditure_org_id,
			X_OR_EXPENDITURE_TYPE		=> l_or_expenditure_type);

Line: 1621


	UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;

Line: 1824


		update psp_payroll_sub_lines
			set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))
		where payroll_line_id = l_line_id and
			NVL(daily_rate,0) <> 0 and
			pay_amount <> 0 and	--- rounding difference to nonzero amount .. 4670588
			rownum = 1;

Line: 1874


		select distinct substr(full_name,1,50) into l_employee_name from per_people_f
		--where person_id = l_person_id; /* Tar#12269298 WVU */

Line: 1877


		effective_start_date = (select max(effective_start_date ) from per_people_f where
		person_id=l_person_id);

Line: 1913


payroll_control_id_a.delete;

Line: 1914


time_period_id_a.delete;

Line: 1915


currency_code_a.delete; -- Bug 6468271

Line: 1920


	UPDATE	psp_payroll_controls
		set number_of_cr = r_payroll_Control_array.r_tot_cr(k),
		number_of_dr = r_payroll_Control_array.r_tot_dr(k),
		total_dr_amount = r_payroll_control_array.r_dr_amount(k),
		total_cr_amount	=r_payroll_control_array.r_cr_amount(k)
	WHERE	payroll_control_id = r_payroll_control_array.r_payroll_control_id(k);

Line: 1931


	update psp_payroll_controls
		set sublines_dr_amount = ( select sum(pay_amount)
					from	psp_payroll_sub_lines
						where payroll_line_id in (
						select payroll_line_id
						from	psp_payroll_lines
							where payroll_control_id =
							r_payroll_control_array.r_payroll_control_id(k)
								and dr_cr_flag = 'D')),
		sublines_cr_amount = ( select sum(pay_amount)
					from	psp_payroll_sub_lines
						where payroll_line_id in (
						select payroll_line_id
						from	psp_payroll_lines
							where payroll_control_id = r_payroll_control_array.r_payroll_control_id(k) and
							dr_cr_flag = 'C'))
		where payroll_control_id	= r_payroll_control_array.r_payroll_control_id(K);

Line: 1962


	r_payroll_control_array.r_payroll_control_id.DELETE;

Line: 1963


	r_payroll_control_array.r_currency_code.DELETE;

Line: 1964


	r_payroll_control_array.r_tot_dr.DELETE;

Line: 1965


	r_payroll_control_array.r_tot_cr.DELETE;

Line: 1966


	r_payroll_control_array.r_dr_amount.DELETE;

Line: 1967


	r_payroll_control_array.r_cr_amount.DELETE;

Line: 1968


	r_payroll_control_array.r_precision.DELETE;

Line: 1969


	r_payroll_control_array.r_ext_precision.DELETE;

Line: 2145


SELECT	DECODE(psp_general.business_days(g_start_date + (ROWNUM-1), g_start_date + (ROWNUM-1), p_assignment_id), 1, 'Y', 'N')
FROM	DUAL
CONNECT BY 1=1
AND	ROWNUM <= (g_end_date + 1) - g_start_date;

Line: 2165


PROCEDURE update_wcal_asg_end_date(x_assignment_id IN NUMBER,
					x_return_status OUT NOCOPY VARCHAR2) IS

/* CURSOR get_asg_end_date_csr IS
SELECT effective_end_date
FROM	per_assignments_f
WHERE assignment_id	= x_assignment_id and
	effective_end_date = (select max(effective_end_date) from per_assignments_f
				where effective_end_date between g_start_date and
					g_end_date);

Line: 2177


SELECT max(effective_end_date)
FROM	per_assignments_f
WHERE assignment_id	= x_assignment_id
--	Introduced the following condition for bug fix 2439207
AND	assignment_type = 'E';

Line: 2211


	fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_END_DATE');

Line: 2218


PROCEDURE update_wcal_asg_begin_date(x_assignment_id IN NUMBER,
					x_return_status OUT NOCOPY VARCHAR2) IS

/* CURSOR get_asg_end_date_csr IS
SELECT effective_end_date
FROM	per_assignments_f
WHERE assignment_id	= x_assignment_id and
	effective_end_date = (select max(effective_end_date) from per_assignments_f
				where effective_end_date between g_start_date and
					g_end_date);

Line: 2231


SELECT min(date_start)
FROM	per_periods_of_service
WHERE	person_id = x_person_id and
	(date_start between g_start_date and g_end_date) ;

Line: 2241


SELECT min(effective_start_date)
FROM	per_assignments_f
WHERE	assignment_id = x_assignment_id
AND	payroll_id = l_payroll_id	-- 3922347
--	Introduced the following condition for bug fix 2439207
AND	assignment_type = 'E';

Line: 2307


	fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE',SUBSTR(SQLERRM,1,100));

Line: 2315


PROCEDURE update_wcal_asg_begin_date(x_person_id IN NUMBER,
					x_return_status OUT NOCOPY VARCHAR2) IS

 CURSOR get_asg_end_date_csr IS
SELECT effective_end_date
FROM	per_assignments_f
WHERE assignment_id	= x_assignment_id and
	effective_end_date = (select max(effective_end_date) from per_assignments_f
				where effective_end_date between g_start_date and
					g_end_date);

Line: 2328


SELECT min(date_start)
FROM	per_periods_of_service
WHERE	person_id = x_person_id and
		(date_start between g_start_date and g_end_date) ;

Line: 2362


	fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_BEGIN_DATE');

Line: 2369


PROCEDURE	UPDATE_WCAL_ASG_STATUS(x_assignment_id IN NUMBER,
					x_return_status OUT NOCOPY VARCHAR2) IS

CURSOR get_asg_status_csr IS
SELECT	effective_start_date,	effective_end_date
FROM	per_assignments_f
WHERE	assignment_id = x_assignment_id and
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and	g_end_date >= effective_end_date )) and
	assignment_status_type_id in (select assignment_status_type_id
					from per_assignment_status_types
					where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') );

Line: 2422


	fnd_msg_pub.add_exc_msg('PSP_PAYTRN','UPDATE_WCAL_ASG_STATUS');

Line: 2425


end UPDATE_WCAL_ASG_STATUS;

Line: 2436


SELECT distinct proposed_salary, previous_salary,
	change_date,last_change_date,pay_basis
FROM	per_pay_proposals_v
WHERE assignment_id	= x_assignment_id and
	element_type_id = x_element_type_id and
	approved='Y' and
	change_date between (trunc(g_start_date)+1) and g_end_date
ORDER BY change_date;

Line: 2451


select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id = x_assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = x_assignment_id
 and piv.element_type_id = x_element_type_id
 and ppp.approved = 'Y'
 --and ppp.change_date <= :g_start_date
 and ppp.change_date between (trunc(g_Start_date)+1) and g_end_date
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date ;

Line: 2476


select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id = x_assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = x_assignment_id
 and piv.element_type_id = x_element_type_id
and ppp.approved = 'Y'
--and ppp.change_date between (trunc(g_Start_date)+1) and g_end_date
 and ppp.change_date < p_change_date
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date desc;

Line: 2500


SELECT distinct proposed_salary, change_date, pay_basis
FROM	per_pay_proposals_v
WHERE assignment_id	= x_assignment_id and
	element_type_id = x_element_type_id and
	change_date <= g_start_date and
	approved = 'Y' order by change_date desc ;

Line: 2514


select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id =x_assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = x_assignment_id
 and piv.element_type_id = x_element_type_id
 and ppp.approved = 'Y'
 --and ppp.change_date <= :g_start_date
 and ppp.change_date =
		(select max(change_date)
		from per_pay_proposals ppp1
		where ppp1.assignment_id = x_assignment_id
		and ppp1.approved = 'Y'
		and ppp1.change_date <= g_start_date)
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date desc;

Line: 2543


SELECT number_per_fiscal_year
FROM	per_time_period_types
WHERE	period_type = (select period_type from per_time_periods
			where time_period_id = x_time_period_id);

Line: 2849


SELECT *
FROM	psp_payroll_lines
WHERE payroll_line_id	= x_payroll_line_id;

Line: 2860


SELECT proposed_salary,
 previous_salary,
 change_date,
 last_change_date,
 pay_basis
FROM	per_pay_proposals_v
WHERE assignment_id = g_payroll_line_rec.assignment_id and
	element_type_id = g_payroll_line_rec.element_type_id and
	approved = 'Y' and
	change_date between (trunc(g_start_date)+1) and g_end_date
ORDER BY change_date;

Line: 2876


select distinct ppp.proposed_salary_n proposed_salary, ppp.change_date
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id = g_payroll_line_rec.assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = g_payroll_line_rec.assignment_id
 and piv.element_type_id = g_payroll_line_rec.element_type_id
and ppp.approved = 'Y'
 --and ppp.change_date <= :g_start_date
 and ppp.change_date between (trunc(g_start_date)+1) and g_end_date
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date;

Line: 2901


select ppp.proposed_salary_n previous_salary, ppp.change_date last_change_date
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id = g_payroll_line_rec.assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = g_payroll_line_rec.assignment_id
 and piv.element_type_id = g_payroll_line_rec.element_type_id
 and ppp.approved = 'Y'
 --and ppp.change_date <= :g_start_date
-- and ppp.change_date between (trunc(g_start_date)+1) and g_end_date
and ppp.change_date < p_change_date
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date desc;

Line: 2935


SELECT change_date, proposed_salary
FROM	per_pay_proposals_v
WHERE	assignment_id = g_payroll_line_rec.assignment_id and
	element_type_id	= g_payroll_line_rec.element_type_id and
	change_date <= g_start_date and
	approved = 'Y' and
	change_date = (select max(change_date) from per_pay_proposals_v
			where assignment_id = g_payroll_line_rec.assignment_id and
			change_date <= g_start_date and approved = 'Y')
ORDER BY change_date;

Line: 2947


SELECT proposed_salary, change_date,pay_basis
FROM	per_pay_proposals_v
WHERE	assignment_id = g_payroll_line_rec.assignment_id and
	element_type_id	= g_payroll_line_rec.element_type_id and
	change_date <= g_start_date and
	approved = 'Y'
	order by change_date desc;

Line: 2957


select ppp.proposed_salary_n proposed_salary, ppp.change_date, ppb.pay_basis
 from per_pay_proposals ppp,
	pay_input_values_f piv,
	per_pay_bases ppb,
	per_all_assignments_f paf
 where paf.assignment_id =g_payroll_line_rec.assignment_id
 and ppp.change_date between paf.effective_start_date and
paf.effective_end_date
 and paf.pay_basis_id = ppb.pay_basis_id
 and ppp.assignment_id = g_payroll_line_rec.assignment_id
 and piv.element_type_id = g_payroll_line_rec.element_type_id
 and ppp.approved = 'Y'
 --and ppp.change_date <= :g_start_date
 and ppp.change_date =
		(select max(change_date)
		from per_pay_proposals ppp1
		where ppp1.assignment_id = g_payroll_line_rec.assignment_id
		and ppp1.approved = 'Y'
		and ppp1.change_date <= g_start_date)
 --and ppb.pay_basis_id = :p_pay_basis_id
 and ppb.input_value_id = piv.input_value_id
 and ppp.change_date
	between piv.effective_start_date and piv.effective_end_date
 order by ppp.change_date desc;

Line: 3120


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
	FROM DUAL;

Line: 3123


	hr_utility.trace('	inserting into Sublines -1');

Line: 3126


	PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_sub_line_end_date,
			X_REASON_CODE			=> 'SALARY_CHANGE',
			X_PAY_AMOUNT			=> round((l_rate_salary + l_balance_salary), g_precision),	-- bug 3109943
			X_DAILY_RATE			=> l_total_daily_rate,
			X_SALARY_USED			=> NVL(l_salary,0),
			X_CURRENT_SALARY		=> NVL(l_salary,0),
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> NULL,
			X_ASSIGNMENT_END_DATE		=> NULL,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R' );

Line: 3161


	hr_utility.trace('	Crossed Insert rec into sub lines');

Line: 3164


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'SALARY_CHANGE',
			X_PARENT_LINE_ID		=> l_sub_line_id,
			X_MODE				=> 'R');

Line: 3193


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
	FROM DUAL;

Line: 3195


	----hr_utility.trace('	Before Insert rec into sub lines 2');

Line: 3196


	hr_utility.trace('	inserting into Sublines -2');

Line: 3197


	PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_sub_line_start_date,
			X_SUB_LINE_END_DATE		=> trunc(g_end_date),
			X_REASON_CODE			=> 'SALARY_CHANGE',
			X_PAY_AMOUNT			=> round((l_rate_salary + l_balance_salary), g_precision), -- bug 3109943
			X_DAILY_RATE			=> l_daily_rate + l_daily_balance,
			X_SALARY_USED			=> NVL(l_proposed_salary,0),
			X_CURRENT_SALARY		=> NVL(l_proposed_salary,0),
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> NULL,
			X_ASSIGNMENT_END_DATE		=> NULL,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R' );

Line: 3233


	----hr_utility.trace('	Crossed Insert rec into sub lines 2');

Line: 3235


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'SALARY_CHANGE',
			X_PARENT_LINE_ID		=> l_sub_line_id,
			X_MODE				=> 'R');

Line: 3269


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 3270


	----hr_utility.trace('	Before Insert rec into sub lines 3');

Line: 3278


 hr_utility.trace('	inserting into Sublines -3');

Line: 3279


	PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> TRUNC(NVL(x_start_date,l_sub_line_start_date)),
			X_SUB_LINE_END_DATE		=> TRUNC(NVL(x_end_date,g_end_date)),
			X_REASON_CODE			=> 'NO_SALARY_CHANGE',
			X_PAY_AMOUNT			=> g_payroll_line_rec.pay_amount,
			X_DAILY_RATE			=> l_daily_rate,
			X_SALARY_USED			=> NVL(l_salary,0),
			X_CURRENT_SALARY		=> NULL,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> NULL,
			X_ASSIGNMENT_END_DATE		=> NULL,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R' );

Line: 3314


	----dbms_output.PUT_LINE('After Insert rec into sub lines 3');

Line: 3316


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'NO_SALARY_CHANGE',
			X_PARENT_LINE_ID		=> l_sub_line_id,
			X_MODE				=> 'R');

Line: 3322


	----dbms_output.PUT_LINE('After Insert rec into sub line reason 3');

Line: 3341


		----dbms_output.PUT_LINE('Before Insert record ');

Line: 3352


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 3354


 hr_utility.trace('	inserting into Sublines -5');

Line: 3355


		PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> TRUNC(NVL(x_start_date,g_start_date)),
			X_SUB_LINE_END_DATE		=> TRUNC(NVL(x_end_date,g_end_date)),
			X_REASON_CODE			=> 'NO_SALARY_CHANGE',
			X_PAY_AMOUNT			=> l_rate_salary ,
			X_DAILY_RATE			=> l_daily_rate + l_daily_balance,
			X_SALARY_USED			=> NVL(l_salary,0),
			X_CURRENT_SALARY		=> NVL(l_salary,0),
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> NULL,
			X_ASSIGNMENT_END_DATE		=> NULL,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R' );

Line: 3391


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'NO_SALARY_CHANGE',
			X_PARENT_LINE_ID		=> l_sub_line_id,
			X_MODE				=> 'R');

Line: 3397


		----dbms_output.PUT_LINE('After Insert record ');

Line: 3421


SELECT effective_start_date
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date between (trunc(g_start_date)+1) and g_end_date and
	effective_start_date = (select min(effective_start_date)
				from per_assignments_f
				where assignment_id = x_assignment_id
				AND	assignment_type ='E' ); --Added for bug 2624259.

Line: 3433


SELECT effective_end_date
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_end_date between g_start_date and (trunc(g_end_date) - 1) and
	effective_end_date = (select max(effective_end_date)
				from per_assignments_f
				where assignment_id = x_assignment_id);

Line: 3443


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id = x_payroll_line_id and
	l_start_date between sub_line_start_date and sub_line_end_date;

Line: 3461


	UPDATE psp_payroll_sub_lines
		SET sub_line_start_date	= trunc(l_start_date),
		reason_code		= 'ASSG_BEGIN_DATE',
		assignment_begin_date = trunc(l_start_date)
	WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3466


	----dbms_output.put_line('Updated sub line with new begin date');

Line: 3479


	UPDATE psp_payroll_sub_lines
		SET sub_line_end_date	= trunc(l_start_date),
		reason_code		= 'ASSG_END_DATE',
		assignment_end_date = trunc(l_start_date)
	WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3484


	----dbms_output.put_line('Updated sub line with new end date');

Line: 3509


SELECT effective_start_date,	effective_end_date
FROM	per_assignments_f
WHERE	assignment_id = x_assignment_id and
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and	g_end_date >= effective_end_date )) and
	assignment_status_type_id in (select assignment_status_type_id
					from per_assignment_status_types
					where per_system_status in ('SUSP_ASSIGN','TERM_ASSIGN') )
ORDER BY effective_start_date;

Line: 3524


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id = x_payroll_line_id and
	(l_start_date between sub_line_start_date and sub_line_end_date or
	l_end_date	between sub_line_start_date and sub_line_end_date);

Line: 3571


		UPDATE psp_payroll_sub_lines
		SET	pay_amount	= 0.00,
		daily_rate	= 0.00,
		reason_code = 'ASSG_STATUS_CHANGE'
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3600


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3602


 hr_utility.trace('	inserting into Sublines -6');

Line: 3603


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3639


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3649


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3651


hr_utility.trace('	inserting into Sublines -7');

Line: 3652


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_start_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3688


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R') ;

Line: 3695


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3705


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3707


 hr_utility.trace('	inserting into Sublines -8');

Line: 3708


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3744


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3769


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3771


 hr_utility.trace('	inserting into Sublines -10');

Line: 3772


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3808


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3815


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3839


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3841


 hr_utility.trace('	inserting into Sublines -12');

Line: 3842


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3878


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3884


		----dbms_output.put_line('After 1st Insert ..');

Line: 3887


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3889


 hr_utility.trace('	inserting into Sublines -13');

Line: 3890


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> NULL,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_start_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> trunc(l_tmp_end_date) + 1,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3926


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3932


		----dbms_output.put_line('After 2nd Insert ..');

Line: 3951


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3953


 hr_utility.trace('	inserting into Sublines -14');

Line: 3954


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 3990


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 3996


		----dbms_output.put_line('After 3rd Insert ..');

Line: 3998


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4023


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4025


hr_utility.trace('	inserting into Sublines -15');

Line: 4026


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4062


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4072


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 4074


 hr_utility.trace('	inserting into Sublines -17');

Line: 4075


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00 ,
			X_SALARY_USED			=> 0.00,
			X_CURRENT_SALARY		=> NULL,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4111


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4117


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4127


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 4129


 hr_utility.trace('	inserting into Sublines -19');

Line: 4130


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00 ,
			X_SALARY_USED			=> 0.00,
			X_CURRENT_SALARY		=> NULL,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4166


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4190


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4192


 hr_utility.trace('	inserting into Sublines -21');

Line: 4193


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> l_tmp_start_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4229


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> 'ASSG_STATUS_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4235


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4271


SELECT date_start
FROM	per_periods_of_service
WHERE	person_id = x_person_id and
		(date_start between g_start_date and g_end_date) ;

Line: 4279


SELECT actual_termination_date
FROM	per_periods_of_service
WHERE	person_id = x_person_id and
		(date_start between g_start_date and g_end_date) ;

Line: 4288


SELECT *
FROM	psp_payroll_sub_lines
WHERE	payroll_line_id = x_payroll_line_id and
	l_tmp_date between sub_line_start_date and sub_line_end_date;

Line: 4317


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4319


 hr_utility.trace('	inserting into Sublines -22');

Line: 4320


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'EMP_BEGIN_DATE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00 ,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> l_tmp_end_date,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4356


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'EMP_BEGIN_DATE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4364


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4366


 hr_utility.trace('	inserting into Sublines -25');

Line: 4367


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> g_sublines_rec.sub_line_end_date,
			X_REASON_CODE			=> 'EMP_BEGIN_DATE',
			X_PAY_AMOUNT			=> g_sublines_rec.pay_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> l_tmp_start_date,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4403


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'EMP_BEGIN_DATE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4411


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4430


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4432


 hr_utility.trace('	inserting into Sublines -28');

Line: 4433


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'EMP_END_DATE',
			X_PAY_AMOUNT			=> g_sublines_rec.pay_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> l_tmp_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4469


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'EMP_END_DATE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4477


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4479


 hr_utility.trace('	inserting into Sublines -30');

Line: 4480


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> g_sublines_rec.sub_line_end_date,
			X_REASON_CODE			=> 'EMP_END_DATE',
			X_PAY_AMOUNT			=> 0.00,
			X_DAILY_RATE			=> 0.00,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> l_tmp_start_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4516


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'EMP_END_DATE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4524


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4549


SELECT effective_start_date, organization_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date < g_start_date and
	effective_start_date = (select max(effective_start_date) from per_assignments_f
		where assignment_id = x_assignment_id
		AND assignment_type ='E' --Added for bug 2624259.
		AND effective_start_date < g_start_date);

Line: 4562


SELECT effective_start_date, effective_end_date, organization_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id
	AND assignment_type ='E' --Added for bug 2624259.
	AND
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 4577


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 4636


		UPDATE psp_payroll_sub_lines
			set organization_id = l_new_org_id
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4663


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4665


 hr_utility.trace('	inserting into Sublines -32');

Line: 4666


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_old_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4702


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4727


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4729


 hr_utility.trace('	inserting into Sublines -33');

Line: 4730


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_new_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4766


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4774


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4800


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4802


 hr_utility.trace('	inserting into Sublines -34');

Line: 4803


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_new_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4839


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4864


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4866


 hr_utility.trace('	inserting into Sublines -35');

Line: 4867


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_old_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4903


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4911


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4934


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4936


 hr_utility.trace('	inserting into Sublines -37');

Line: 4937


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_old_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 4973


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 4998


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5000


 hr_utility.trace('	inserting into Sublines -39');

Line: 5001


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_new_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5037


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5062


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5064


 hr_utility.trace('	inserting into Sublines -42');

Line: 5065


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> l_old_org_id,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5101


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'ORG_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5109


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5142


SELECT effective_start_date, job_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date < g_start_date and
	effective_start_date = (select max(effective_start_date) from per_assignments_f
		where assignment_id = x_assignment_id
		AND assignment_type ='E' --Added for bug 2624259.
		AND effective_start_date < g_start_date);

Line: 5155


SELECT effective_start_date, effective_end_date, job_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id
	AND assignment_type ='E' --Added for bug 2624259.
	AND
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 5170


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 5221


		UPDATE psp_payroll_sub_lines
			set job_id = l_new_job_id
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5248


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5250


 hr_utility.trace('	inserting into Sublines -52');

Line: 5251


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_old_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5287


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5312


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5314


 hr_utility.trace('	inserting into Sublines -62');

Line: 5315


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_new_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5351


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 5359


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5385


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5387


 hr_utility.trace('	inserting into Sublines -92');

Line: 5388


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_new_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5424


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5449


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5451


 hr_utility.trace('	inserting into Sublines -102');

Line: 5452


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_old_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5488


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 5496


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5519


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5521


 hr_utility.trace('	inserting into Sublines -202');

Line: 5522


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_old_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5558


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5583


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5585


 hr_utility.trace('	inserting into Sublines -302');

Line: 5586


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_new_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5622


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5647


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5649


 hr_utility.trace('	inserting into Sublines -402');

Line: 5650


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> l_old_job_id,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5686


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'JOB_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5694


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5732


SELECT effective_start_date, position_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date < g_start_date and
	effective_start_date = (select max(effective_start_date) from per_assignments_f
		where assignment_id = x_assignment_id
		AND assignment_type ='E' --Added for bug 2624259.
		AND effective_start_date < g_start_date);

Line: 5745


SELECT effective_start_date, effective_end_date, position_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id
	AND assignment_type ='E' --Added for bug 2624259.
	AND
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 5760


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 5811


		UPDATE psp_payroll_sub_lines
			set position_id = l_new_position_id
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5838


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5840


 hr_utility.trace('	inserting into Sublines -502');

Line: 5841


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_old_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5877


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5902


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5904


 hr_utility.trace('	inserting into Sublines -502');

Line: 5905


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_new_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 5941


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 5949


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5975


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5977


 hr_utility.trace('	inserting into Sublines -702');

Line: 5978


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_new_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6014


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6039


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6041


 hr_utility.trace('	inserting into Sublines -802');

Line: 6042


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_old_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6078


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 6086


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6109


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6111


 hr_utility.trace('	inserting into Sublines -902');

Line: 6112


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_old_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6148


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6173


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6175


 hr_utility.trace('	inserting into Sublines -802');

Line: 6176


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_new_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6212


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6237


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6239


 hr_utility.trace('	inserting into Sublines -1002');

Line: 6240


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> l_old_position_id,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6276


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'POSITION_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6284


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6325


SELECT effective_start_date, grade_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date < g_start_date and
	effective_start_date = (select max(effective_start_date) from per_assignments_f
		where assignment_id = x_assignment_id
		AND	assignment_type ='E' --Added for bug 2624259.
		AND	effective_start_date < g_start_date);

Line: 6338


SELECT effective_start_date, effective_end_date, grade_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id
	AND assignment_type ='E'	--Added for bug 2624259.
	AND
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 6353


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 6402


		UPDATE psp_payroll_sub_lines
			set grade_id = l_new_grade_id
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6429


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6431


 hr_utility.trace('	inserting into Sublines -2002');

Line: 6432


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=>g_sublines_rec.position_id,
			X_GRADE_ID			=> l_old_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6468


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6493


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6495


 hr_utility.trace('	inserting into Sublines -3002');

Line: 6496


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=>g_sublines_rec.position_id,
			X_GRADE_ID			=> l_new_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6532


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6540


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6566


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6568


 hr_utility.trace('	inserting into Sublines -4002');

Line: 6569


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=>g_sublines_rec.position_id,
			X_GRADE_ID			=> l_new_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6605


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6630


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6632


 hr_utility.trace('	inserting into Sublines -5002');

Line: 6633


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=>g_sublines_rec.position_id,
			X_GRADE_ID			=> l_old_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6669


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 6677


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6700


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6702


 hr_utility.trace('	inserting into Sublines -6002');

Line: 6703


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=>g_sublines_rec.position_id,
			X_GRADE_ID			=> l_old_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6739


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6764


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6766


 hr_utility.trace('	inserting into Sublines -7002');

Line: 6767


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> l_new_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6803


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6828


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6830


 hr_utility.trace('	inserting into Sublines -8002');

Line: 6831


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> l_old_grade_id,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 6867


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'GRADE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 6875


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6920


SELECT effective_start_date, people_group_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id and
	effective_start_date < g_start_date and
	effective_start_date = (select max(effective_start_date) from per_assignments_f
		where assignment_id = x_assignment_id
		AND	assignment_type ='E'	--Added for bug 2624259.
		AND	effective_start_date < g_start_date);

Line: 6933


SELECT effective_start_date, effective_end_date, people_group_id
FROM	per_assignments_f
WHERE assignment_id = x_assignment_id
	AND assignment_type ='E'	--Added for bug 2624259.
	AND
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 6948


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 6997


		UPDATE psp_payroll_sub_lines
			set people_group_id = l_new_ppgroup_id
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7024


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7026


 hr_utility.trace('	inserting into Sublines -9002');

Line: 7027


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_old_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7063


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7088


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7090


 hr_utility.trace('	inserting into Sublines -2Y');

Line: 7091


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_new_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7127


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7135


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7161


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7163


 hr_utility.trace('	inserting into Sublines -2OX');

Line: 7164


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_new_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7200


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7225


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7227


 hr_utility.trace('	inserting into Sublines -2LXL');

Line: 7228


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_old_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7264


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PPGROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 7272


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7295


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7297


 hr_utility.trace('	inserting into Sublines -2UIORA');

Line: 7298


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_old_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7334


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7359


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7361


 hr_utility.trace('	inserting into Sublines -2JADF');

Line: 7362


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_new_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7398


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7423


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7425


 hr_utility.trace('	inserting into Sublines -299ek');

Line: 7426


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> l_old_ppgroup_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7462


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'PEOPLE_GROUP_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7470


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7521


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 7567


 dbms_sql.parse(l_cur_handle,'SELECT ' || l_fte_value || ' FROM per_assignments_f WHERE assignment_id = ' ||
		to_char(x_assignment_id) || ' and effective_start_date = (select max(effective_start_date)' ||
		' from per_assignments_f where assignment_id = ' || to_char(x_assignment_id)		||
		' AND assignment_type = '||''''||'E'||''''						||
		' and effective_start_date < (select min(effective_start_date) from	per_assignments_f '	||
		' where assignment_id = ' || to_char(x_assignment_id)					||
		' AND assignment_type = '||''''||'E'||''''						||
		' and (( :g_start_date '									||
		' between effective_start_date and effective_end_date) or ( :g_end_date between '	||
		' effective_start_date and effective_end_date) or ( :g_start_date <= effective_start_date' ||
		' and :g_end_date >= effective_end_date )) ))',dbms_sql.V7);

Line: 7610


 dbms_sql.parse(l_cur_handle,'SELECT effective_start_date, effective_end_date, ' || l_fte_value	||
		' FROM	per_assignments_f WHERE assignment_id = ' || to_char(x_assignment_id)	||
		' AND assignment_type = '||''''||'E'||''''						||
		' and (:g_start_date between effective_start_date and effective_end_date or '	||
			':g_end_date between effective_start_date and effective_end_date or (:g_start_date '	||
		' <= effective_start_date and :g_end_date >= effective_end_date )) order by '		||
		' effective_start_date ',dbms_sql.V7);

Line: 7676


		UPDATE psp_payroll_sub_lines
		set fte = l_new_fte
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7703


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
				FROM DUAL;

Line: 7705


 hr_utility.trace('	inserting into Sublines -2kdfd');

Line: 7706


		PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7742


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7767


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7769


 hr_utility.trace('	inserting into Sublines -2LKJL:JL');

Line: 7770


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7806


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7812


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7838


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7840


 hr_utility.trace('	inserting into Sublines -2UUUUUUAA');

Line: 7841


		PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7877


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7902


			SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7904


 hr_utility.trace('	inserting into Sublines -2KKKKK');

Line: 7905


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 7941


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 7949


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7972


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7974


 hr_utility.trace('	inserting into Sublines -2OOOPP888');

Line: 7975


		PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8011


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8036


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8038


 hr_utility.trace('	inserting into Sublines -27777MMMN');

Line: 8039


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8075


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8100


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8102


 hr_utility.trace('	inserting into Sublines -2EEEERRSS');

Line: 8103


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_fte,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8139


			PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8147


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8182


SELECT effective_start_date, value
-- FROM	per_assignment_budget_values Comented for bug 4055483
FROM	per_assignment_budget_values_f
WHERE assignment_id = x_assignment_id and unit = 'FTE' and
	effective_start_date =
		(select max(effective_start_date) -- from per_assignment_budget_values Commented for bug 4055483
		from per_assignment_budget_values_f
		where assignment_id = x_assignment_id and	unit = 'FTE' and
		effective_start_date < (select min(effective_start_date)
					--from	per_assignment_budget_values Commented for bug 4055483
						from	per_assignment_budget_values_f
						where assignment_id = x_assignment_id and
						unit = 'FTE' and
						((g_start_date between effective_start_date and effective_end_date) or
						(g_end_date	between effective_start_date and effective_end_date) or
					(g_start_date <= effective_start_date and g_end_date >= effective_end_date )) ));

Line: 8204


SELECT effective_start_date, effective_end_date, value
-- FROM	per_assignment_budget_values Commented for Bug 4055483
FROM	per_assignment_budget_values_f
WHERE assignment_id = x_assignment_id and unit = 'FTE' and
	(g_start_date between effective_start_date and effective_end_date or
	g_end_date	between effective_start_date and effective_end_date or
	(g_start_date <= effective_start_date and g_end_date >= effective_end_date ))
order by effective_start_date;

Line: 8219


SELECT *
FROM	psp_payroll_sub_lines
WHERE payroll_line_id	= x_payroll_line_id and
	((sub_line_start_date between l_current_start_date and l_current_end_date) or
	(sub_line_end_date	between l_current_start_date and l_current_end_date) or
	(sub_line_start_date >= l_current_start_date and sub_line_end_date >= l_current_end_date))
order by sub_line_start_date;

Line: 8279


		UPDATE psp_payroll_sub_lines
			set fte = l_new_value
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8306


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8308


 hr_utility.trace('	inserting into Sublines -2WWWEEERR');

Line: 8309


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> g_sublines_rec.sub_line_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8345


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8370


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8372


 hr_utility.trace('	inserting into Sublines -29999*****888');

Line: 8373


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8409


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8417


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8443


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8445


 hr_utility.trace('	inserting into Sublines -2DDDDDD');

Line: 8446


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8482


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8507


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8509


 hr_utility.trace('	inserting into Sublines -2UKOSO');

Line: 8510


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8546


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R' );

Line: 8554


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8577


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8579


 hr_utility.trace('	inserting into Sublines -2JYUPA');

Line: 8580


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8616


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8641


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8643


 hr_utility.trace('	inserting into Sublines -2NBMM');

Line: 8644


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_new_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8680


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8705


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8707


 hr_utility.trace('	inserting into Sublines -2TOPP');

Line: 8708


			PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> l_tmp_start_date,
			X_SUB_LINE_END_DATE		=> l_tmp_end_date,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PAY_AMOUNT			=> l_amount,
			X_DAILY_RATE			=> g_sublines_rec.daily_rate,
			X_SALARY_USED			=> g_sublines_rec.salary_used,
			X_CURRENT_SALARY		=> g_sublines_rec.current_salary,
			X_FTE				=> l_old_value,
			X_ORGANIZATION_ID		=> g_sublines_rec.organization_id,
			X_JOB_ID			=> g_sublines_rec.job_id,
			X_POSITION_ID			=> g_sublines_rec.position_id,
			X_GRADE_ID			=> g_sublines_rec.grade_id,
			X_PEOPLE_GRP_ID		=> g_sublines_rec.people_group_id,
			X_EMPLOYMENT_BEGIN_DATE		=> g_sublines_rec.employment_begin_date,
			X_EMPLOYMENT_END_DATE		=> g_sublines_rec.employment_end_date,
			X_EMPLOYEE_STATUS_INACTIVE_DAT	=> g_sublines_rec.employee_status_inactive_date,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> g_sublines_rec.employee_status_active_date,
			X_ASSIGNMENT_BEGIN_DATE		=> g_sublines_rec.assignment_begin_date,
			X_ASSIGNMENT_END_DATE		=> g_sublines_rec.assignment_end_date,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE				=> 'R');

Line: 8744


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID				=> l_rowid,
			X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
			X_REASON_CODE			=> 'FTE_CHANGE',
			X_PARENT_LINE_ID		=> g_sublines_rec.payroll_sub_line_id,
			X_MODE				=> 'R');

Line: 8752


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8804


SELECT	count(*)
FROM	per_assignments_f paf,
	per_assignment_status_types	past
WHERE	assignment_id			=		x_assignment_id
AND	g_start_date			<=		effective_end_date
AND	g_end_date			>=		effective_start_date
AND	past.assignment_status_type_id =		paf.assignment_status_type_id
AND	past.per_system_status	NOT IN	('ACTIVE_ASSIGN');

Line: 8814


SELECT	min(paf.effective_start_date)
FROM	per_assignments_f	paf
WHERE	paf.assignment_id	=	x_assignment_id
AND	assignment_type	=	'E'	--Added for bug 2624259.
AND	g_start_date		<=	paf.effective_end_date
AND	g_end_date		>=	paf.effective_start_date
AND	payroll_id = l_payroll_id; ---3922347

Line: 8874


		select assignment_number into l_assignment_number from per_assignments_f where assignment_id =x_assignment_id
		and effective_start_date=(select max(effective_start_date) from per_assignments_f where
		assignment_id=x_assignment_id);

Line: 8900


					This procedure inserts a single line
					into psp_payroll_lines and psp_payroll_sub_lines
					with sub line start date and sub line end date
					as date earned
amakrish		01-Apr-2008     Changed the sub line start date and sub line end date
					to be least of date earned or payroll period end date
					for bug 6886237

***************************************************************************************************/
PROCEDURE	CREATE_SLINE_TERM_EMP ( x_payroll_line_id	IN	NUMBER,
					x_reason		IN	VARCHAR2,
					x_return_status	OUT NOCOPY	VARCHAR2)
IS
l_sub_line_id	NUMBER(10);

Line: 8918


SELECT *
FROM	psp_payroll_lines ppl
WHERE	ppl.payroll_line_id	=	x_payroll_line_id;

Line: 8932


	SELECT end_date
	INTO l_tp_end_date
	FROM per_time_periods
	WHERE time_period_id = (select time_period_id from psp_payroll_controls
	                        where payroll_control_id = (select payroll_control_id from
	                                                    psp_payroll_lines
	                                                    where payroll_line_id = x_payroll_line_id));

Line: 8941


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 8942


 hr_utility.trace('	inserting into Sublines -2UISISI');

Line: 8943


	PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
			X_ROWID			=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_PAYROLL_LINE_ID		=> x_payroll_line_id,
			X_SUB_LINE_START_DATE		=> least(trunc(g_payroll_line_rec.effective_Date), trunc(l_tp_end_date)),  /*Bug 6886237*/
			X_SUB_LINE_END_DATE		=> least(trunc(g_payroll_line_rec.effective_Date), trunc(l_tp_end_date)),  /*Bug 6886237*/
			X_REASON_CODE			=> x_reason,
			X_PAY_AMOUNT			=> g_payroll_line_rec.pay_amount,
			X_DAILY_RATE			=> g_payroll_line_rec.pay_amount,
			X_SALARY_USED			=> g_payroll_line_rec.pay_amount,
			X_CURRENT_SALARY		=> NULL,
			X_FTE				=> NULL,
			X_ORGANIZATION_ID		=> NULL,
			X_JOB_ID			=> NULL,
			X_POSITION_ID			=> NULL,
			X_GRADE_ID			=> NULL,
			X_PEOPLE_GRP_ID		=> NULL,
			X_EMPLOYMENT_BEGIN_DATE	=> NULL,
			X_EMPLOYMENT_END_DATE		=> NULL,
			X_EMPLOYEE_STATUS_INACTIVE_DAT => NULL,
			X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
			X_ASSIGNMENT_BEGIN_DATE	=> NULL,
			X_ASSIGNMENT_END_DATE		=> NULL,
			x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
			x_attribute1			=> NULL,
			x_attribute2			=> NULL,
			x_attribute3			=> NULL,
			x_attribute4			=> NULL,
			x_attribute5			=> NULL,
			x_attribute6			=> NULL,
			x_attribute7			=> NULL,
			x_attribute8			=> NULL,
			x_attribute9			=> NULL,
			x_attribute10			=> NULL,
			X_MODE			=> 'R' );

Line: 8981


		PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
			X_ROWID			=> l_rowid,
			X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
			X_REASON_CODE			=> x_reason,
			X_PARENT_LINE_ID		=> l_sub_line_id,
			X_MODE			=> 'R');

Line: 9124


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 9126


 hr_utility.trace('	inserting into Sublines -2LLLLLLLALALAL');

Line: 9127


	PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
		(X_ROWID			=> l_rowid,
		X_PAYROLL_SUB_LINE_ID		=> l_sub_line_id,
		X_PAYROLL_LINE_ID		=> p_payroll_line_id,
		X_SUB_LINE_START_DATE		=> l_start_date,
		X_SUB_LINE_END_DATE		=> l_end_date,
		X_REASON_CODE			=> 'SALARY_CHANGE',
		X_PAY_AMOUNT			=> l_final_salary,
		X_DAILY_RATE			=> l_final_daily_rate,
		X_SALARY_USED			=> l_final_salary,
		X_CURRENT_SALARY		=> l_final_salary,
		X_FTE				=> NULL,
		X_ORGANIZATION_ID		=> NULL,
		X_JOB_ID			=> NULL,
		X_POSITION_ID			=> NULL,
		X_GRADE_ID			=> NULL,
		X_PEOPLE_GRP_ID			=> NULL,
		X_EMPLOYMENT_BEGIN_DATE		=> NULL,
		X_EMPLOYMENT_END_DATE		=> NULL,
		X_EMPLOYEE_STATUS_INACTIVE_DAT	=> NULL,
		X_EMPLOYEE_STATUS_ACTIVE_DATE	=> NULL,
		X_ASSIGNMENT_BEGIN_DATE		=> NULL,
		X_ASSIGNMENT_END_DATE		=> NULL,
		x_attribute_category		=> NULL,		-- Introduced DFF parameters for bug fix 2908859
		x_attribute1			=> NULL,
		x_attribute2			=> NULL,
		x_attribute3			=> NULL,
		x_attribute4			=> NULL,
		x_attribute5			=> NULL,
		x_attribute6			=> NULL,
		x_attribute7			=> NULL,
		x_attribute8			=> NULL,
		x_attribute9			=> NULL,
		x_attribute10			=> NULL,
		X_MODE				=> 'R' );

Line: 9165


	PSP_SUB_LINE_REASONS_PKG.INSERT_ROW
		(X_ROWID		=> l_rowid,
		X_PAYROLL_SUB_LINE_ID	=> l_sub_line_id,
		X_REASON_CODE		=> 'SALARY_CHANGE',
		X_PARENT_LINE_ID	=> l_sub_line_id,
		X_MODE			=> 'R');