[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name LIKE 'Action Information DF'
AND descriptive_flex_context_code = p_context_code
AND application_column_name LIKE p_application_column_name
AND enabled_flag = 'Y';
SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name = 'Action Information DF'
AND descriptive_flex_context_code = p_context_code
AND application_column_name = UPPER (p_node);
SELECT paa_chk.serial_number
FROM pay_assignment_actions paa_xfr,
pay_action_interlocks pai_xfr,
pay_action_interlocks pai_chk,
pay_assignment_actions paa_chk,
pay_payroll_actions ppa_chk
WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
AND pai_xfr.locked_action_id = pai_chk.locked_action_id
AND pai_chk.locking_action_id = paa_chk.assignment_action_id
AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id
AND ppa_chk.action_type = 'H'
AND paa_xfr.assignment_action_id = g_action_ctx_id;
SELECT ppf.payroll_name payroll_name
,ptp.period_name period_name
,ptp.period_type period_type
,ptp.start_date start_date
,ptp.end_date end_date
,pai.effective_date payment_date
FROM per_time_periods ptp
,pay_payrolls_f ppf
,pay_action_information pai
WHERE ppf.payroll_id = ptp.payroll_id
AND pai.effective_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
AND ptp.time_period_id = pai.action_information16
AND pai.action_context_type = 'AAP'
AND pai.action_information_category = 'EMPLOYEE DETAILS'
AND (pai.action_context_id = p_action_context_id
OR pai.action_context_id = ( SELECT paa.source_action_id
FROM pay_assignment_actions paa
WHERE paa.assignment_action_id = p_action_context_id
-- AND paa.assignment_id = pai.assignment_id
));
SELECT pai.action_information2 element_type_id
,pai.action_information3 input_value_id
,decode(pai1.action_information8,NULL,pai.action_information4,
pai.action_information4||'('||pai1.action_information8||')') Name
,pai.action_information5 type
,pai.action_information6 uom
,sum(pai1.action_information4) value
FROM pay_action_information pai
,pay_action_information pai1
,pay_assignment_actions paa
WHERE pai.action_context_type = 'PA'
AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
AND pai1.action_context_type = 'AAP'
AND pai.action_information5 <> 'F'
AND pai1.action_information3 <> 'F'
/*AND ( pai1.action_context_id IN ( SELECT paa.assignment_action_id
FROM pay_assignment_actions paa
WHERE paa.source_action_id = p_action_context_id
AND paa.assignment_id = pai1.assignment_id)
OR pai1.action_context_id = p_action_context_id)*/
and pai1.action_information_category = 'EMEA ELEMENT INFO'
and pai.action_information2 = pai1.action_information1
and pai.action_information3 = pai1.action_information2
and pai.action_context_id = paa.payroll_action_id
and pai1.action_context_id = paa.assignment_action_id
and paa.assignment_action_id = p_action_context_id
group by pai.action_information2
,pai.action_information3
,pai.action_information4
,pai.action_information5
,pai.action_information6
,pai1.action_information8
ORDER BY pai.action_information5,pai1.action_information8 DESC;
SELECT pai.action_information2 element_type_id
,pai.action_information3 input_value_id
,decode(pai1.action_information8,NULL,pai.action_information4,
pai.action_information4||'('||pai1.action_information8||')') Name
,pai.action_information5 type
,pai.action_information6 uom
,pai1.action_information4 value
FROM pay_action_information pai
,pay_action_information pai1
,pay_assignment_actions paa
WHERE pai.action_context_type = 'PA'
AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
AND pai1.action_context_type = 'AAP'
AND pai.action_information5 = 'F'
AND pai1.action_information3 = 'F'
/*AND ( pai1.action_context_id IN ( SELECT paa.assignment_action_id
FROM pay_assignment_actions paa
WHERE paa.source_action_id = p_action_context_id
AND paa.assignment_id = pai1.assignment_id)
OR pai1.action_context_id = p_action_context_id)*/
AND pai1.action_information_category = 'EMEA ELEMENT INFO'
AND pai.action_information2 = pai1.action_information1
AND pai.action_information3 = pai1.action_information2
AND pai.action_context_id = paa.payroll_action_id
AND pai1.action_context_id = paa.assignment_action_id
AND paa.assignment_action_id = p_action_context_id
/* Commented for Bug 9525527 */
/* GROUP BY pai.action_information2
,pai.action_information3
,pai.action_information4
,pai.action_information5
,pai.action_information6
,pai1.action_information4
,pai1.action_information8 */
ORDER BY pai.action_information4,pai.action_information5,pai1.action_information8 DESC;
SELECT name
FROM pay_input_values_f
WHERE input_value_id = p_input_value_id;
SELECT pai.action_information4 Name
,pai.action_information2 defined_balance_id
,pai.action_information6 type
,pai1.action_information4 value
,pai1.action_information6 uom
FROM pay_action_information pai
,pay_action_information pai1
,pay_assignment_actions paa
WHERE pai.action_context_type = 'PA'
AND pai.action_information_category = 'EMEA BALANCE DEFINITION'
AND pai1.action_context_type = 'AAP'
AND pai1.action_information_category = 'EMEA BALANCES'
AND pai.action_information6 = 'OBAL'
AND pai1.action_information2 = 'OBAL'
AND pai.action_information2 = pai1.action_information1
AND pai.action_context_id = paa.payroll_action_id
AND pai1.action_context_id = paa.assignment_action_id
AND paa.assignment_action_id in
(SELECT paa1.assignment_action_id
FROM pay_assignment_actions paa1
WHERE paa1.source_action_id = p_action_context_id
AND paa1.action_status = 'C'
UNION
SELECT p_action_context_id
FROM dual )
ORDER BY pai.action_information5,pai1.action_information5 DESC;