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


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


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


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


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


SELECT cost_id
FROM	PSP_PAYROLL_LINES
WHERE	cost_id = g_pay_costs_rec.cost_id;

Line: 358


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

Line: 365


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


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


SELECT	legislation_code
FROM	per_business_groups
WHERE	business_group_id = l_resp_business_group_id;

Line: 466


SELECT	currency_code
FROM	gl_sets_of_books gsob
WHERE	set_of_books_id = l_resp_set_of_books_id;

Line: 472


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


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

Line: 500


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


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


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


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


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


SELECT	name
FROM	hr_all_organization_units hou
WHERE	organization_id = l_or_expenditure_org_id;

Line: 576


SELECT	segment1
FROM	pa_projects_all
WHERE	project_id = l_or_project_id;

Line: 581


SELECT	org_id
FROM	pa_projects_all
WHERE	project_id = l_or_project_id;

Line: 586


SELECT	task_number
FROM	pa_tasks
WHERE	task_id = l_or_task_id;

Line: 591


SELECT	award_number
FROM	gms_awards_all
WHERE	award_id = l_or_award_id;

Line: 596


SELECT	expenditure_type
FROM	pa_expenditure_types
WHERE	expenditure_type = l_or_expenditure_type;

Line: 812


 SELECT psp_st_run_id_s.nextval
 INTO l_run_id
 FROM dual;

Line: 837


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

Line: 934


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


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


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


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


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


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


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


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


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


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


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


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

		hr_utility.trace('	UPDATE_WCAL_ASG_END_DATE');

Line: 1146


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

Line: 1149


		l_error_api_name	:= 'UPDATE_WCAL_ASG_END_DATE : ';

Line: 1153


		hr_utility.trace('	UPDATE_WCAL_ASG_BEGIN_DATE');

Line: 1154


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

Line: 1157


		l_error_api_name	:= 'UPDATE_WCAL_ASG_BEGIN_DATE : ';

Line: 1165


		hr_utility.trace('	UPDATE_WCAL_ASG_STATUS');

Line: 1166


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

Line: 1169


		l_error_api_name	:= 'UPDATE_WCAL_ASG_STATUS : ';

Line: 1172


		hr_utility.trace('	AFTER UPDATE_WCAL_ASG_STATUS');

Line: 1226


		-- If first record insert a record in psp_payroll_controls


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

Line: 1276


		SELECT PSP_PAYROLL_CONTROLS_S.NEXTVAL into l_export_id
			FROM DUAL;

Line: 1301


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


			update psp_payroll_controls
			set run_id = l_run_id
			where payroll_control_id = l_export_id;

Line: 1376


		SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_line_id
		FROM DUAL;

Line: 1387


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


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


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


	UPDATE PSP_PAYROLL_LINES set balance_amount=l_balance_amount where payroll_line_id=l_line_id;

Line: 1762


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


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


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

Line: 1839


payroll_control_id_a.delete;

Line: 1840


time_period_id_a.delete;

Line: 1841


currency_code_a.delete; -- Bug 6468271

Line: 1846


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


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


	r_payroll_control_array.r_payroll_control_id.DELETE;

Line: 1889


	r_payroll_control_array.r_currency_code.DELETE;

Line: 1890


	r_payroll_control_array.r_tot_dr.DELETE;

Line: 1891


	r_payroll_control_array.r_tot_cr.DELETE;

Line: 1892


	r_payroll_control_array.r_dr_amount.DELETE;

Line: 1893


	r_payroll_control_array.r_cr_amount.DELETE;

Line: 1894


	r_payroll_control_array.r_precision.DELETE;

Line: 1895


	r_payroll_control_array.r_ext_precision.DELETE;

Line: 2071


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


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


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


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

Line: 2144


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


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


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


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

Line: 2241


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


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


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

Line: 2295


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


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

Line: 2351


end UPDATE_WCAL_ASG_STATUS;

Line: 2362


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


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


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


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


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


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


SELECT *
FROM	psp_payroll_lines
WHERE payroll_line_id	= x_payroll_line_id;

Line: 2786


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


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


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
	FROM DUAL;

Line: 3049


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

Line: 3052


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


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

Line: 3090


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
	FROM DUAL;

Line: 3121


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

Line: 3122


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

Line: 3123


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


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

Line: 3161


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 3196


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

Line: 3204


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

Line: 3205


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


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

Line: 3242


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


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

Line: 3267


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

Line: 3278


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 3280


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

Line: 3281


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


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


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

Line: 3347


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


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


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


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


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

Line: 3405


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


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

Line: 3435


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


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3528


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

Line: 3529


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3577


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

Line: 3578


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3631


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3633


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

Line: 3634


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


		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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3697


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

Line: 3698


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3765


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3767


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

Line: 3768


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


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


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

Line: 3813


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3815


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

Line: 3816


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


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


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

Line: 3877


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3879


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

Line: 3880


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


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


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

Line: 3924


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 3949


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 3951


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

Line: 3952


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


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


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 4000


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

Line: 4001


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4053


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
		FROM DUAL;

Line: 4055


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

Line: 4056


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4118


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

Line: 4119


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4197


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4245


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

Line: 4246


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4292


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

Line: 4293


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4356


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4358


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

Line: 4359


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4405


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

Line: 4406


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4475


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4591


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

Line: 4592


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4655


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

Line: 4656


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4726


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4728


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

Line: 4729


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4792


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

Line: 4793


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 4860


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4862


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

Line: 4863


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4926


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

Line: 4927


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 4990


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

Line: 4991


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5068


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5176


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

Line: 5177


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5240


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

Line: 5241


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5311


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5313


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

Line: 5314


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5377


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

Line: 5378


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5445


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5447


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

Line: 5448


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5511


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

Line: 5512


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5575


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

Line: 5576


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5658


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5766


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

Line: 5767


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5830


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

Line: 5831


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 5901


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5903


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

Line: 5904


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 5967


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

Line: 5968


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6035


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6037


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

Line: 6038


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6101


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

Line: 6102


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6165


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

Line: 6166


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6251


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6357


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

Line: 6358


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6421


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

Line: 6422


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6492


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6494


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

Line: 6495


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6558


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

Line: 6559


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6626


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6628


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

Line: 6629


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6692


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

Line: 6693


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6756


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

Line: 6757


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 6846


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


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


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 6952


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

Line: 6953


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7016


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

Line: 7017


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7087


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7089


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

Line: 7090


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7153


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

Line: 7154


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7221


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7223


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

Line: 7224


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7287


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

Line: 7288


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7351


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

Line: 7352


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7447


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


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


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


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

Line: 7629


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
				FROM DUAL;

Line: 7631


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

Line: 7632


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7695


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

Line: 7696


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


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


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7764


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7766


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

Line: 7767


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


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


			SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7830


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

Line: 7831


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


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


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 7898


		SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7900


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

Line: 7901


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 7964


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

Line: 7965


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


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


			SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8028


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

Line: 8029


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


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


			DELETE psp_payroll_sub_lines
			WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8108


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


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


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


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

Line: 8232


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8234


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

Line: 8235


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8298


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

Line: 8299


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8369


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8371


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

Line: 8372


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8435


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

Line: 8436


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8503


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8505


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

Line: 8506


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8569


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

Line: 8570


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
			FROM DUAL;

Line: 8633


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

Line: 8634


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


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


		DELETE psp_payroll_sub_lines
		WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line: 8730


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


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


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


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


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

Line: 8858


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 8868


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

Line: 8869


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


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


	SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

Line: 9052


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

Line: 9053


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


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