APPS.PAY_JP_GET_MONTH_BALANCE_PKG SQL Statements

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

Line: 25

		select balance_type_id
		into	l_balance_type_id
		from	pay_balance_types
		where	balance_name = p_balance_name
		and	((business_group_id is null and legislation_code = 'JP')
			or business_group_id = p_business_group_id);

Line: 32

		select	effective_date,
			add_months(last_day(effective_date),(-1 * abs(p_months_prior))),
			add_months(last_day(effective_date), (-1 + (-1 * abs(p_months_prior)))) + 1
        	into	l_effective_date,
			l_end_month_date,
			l_start_month_date
		from	fnd_sessions
		where	session_id = userenv('sessionid');

Line: 42

			SELECT	NVL(SUM(TARGET.result_value * FEED.scale),0)
			INTO	l_balance
			FROM
				pay_run_result_values	TARGET,
				pay_balance_feeds_f	FEED,
				pay_run_results		RR,
				pay_payroll_actions	PACT,
				pay_assignment_actions	ASSACT
			WHERE	ASSACT.assignment_id = p_assignment_id
			AND	ASSACT.payroll_action_id = PACT.payroll_action_id
			AND	PACT.effective_date
				between l_start_month_date and l_end_month_date
			AND	RR.assignment_action_id = ASSACT.assignment_action_id
			AND	RR.status IN ('P','PA')
			AND	FEED.balance_type_id = l_balance_type_id
			AND	PACT.effective_date
				between FEED.effective_start_date and FEED.effective_end_date
			AND	TARGET.run_result_id = RR.run_result_id
			AND	TARGET.input_value_id = FEED.input_value_id
			AND	NVL(TARGET.result_value,'0') <> '0';

Line: 90

		select	balance_type_id
		into	l_balance_type_id
		from	pay_balance_types
		where	balance_name = P_BALANCE_NAME
		and	((business_group_id is null and legislation_code = 'JP')
			or business_group_id = p_business_group_id);

Line: 97

		select	effective_date,
			add_months(last_day(effective_date),(-1 * abs(p_months_prior))),
			add_months(last_day(effective_date), (-1 + (-1 * abs(p_months_prior)))) + 1
		into	l_effective_date,
			l_end_month_date,
			l_start_month_date
		from	fnd_sessions
		where	session_id = userenv('sessionid');

Line: 107

			SELECT	NVL(SUM(TARGET.result_value * FEED.scale),0)
			INTO	l_balance
			FROM	pay_run_result_values	TARGET,
				pay_balance_feeds_f	FEED,
				pay_run_results		RR,
				pay_payroll_actions	PACT,
				pay_assignment_actions	ASSACT
			WHERE	ASSACT.assignment_id = p_assignment_id
			AND	ASSACT.payroll_action_id = PACT.payroll_action_id
			AND	PACT.action_type IN ('B','V')
			AND	PACT.effective_date
				between l_start_month_date and l_end_month_date
			AND	RR.assignment_action_id = ASSACT.assignment_action_id
			AND	RR.status IN ('P','PA')
			AND	FEED.balance_type_id = l_balance_type_id
			AND	PACT.effective_date
				between FEED.effective_start_date and FEED.effective_end_date
			AND	TARGET.run_result_id = RR.run_result_id
			AND	TARGET.input_value_id = FEED.input_value_id
			AND	NVL(TARGET.result_value,'0') <> '0';