The following lines contain the word 'select', 'insert', 'update' or 'delete':
updated other procedures as necessary for Payroll
Simulation.
07-Mar-2013 emunisek 115.16 16281614 Moved the procedure SIMULATION_GENERATE
to package PAY_US_PAYSLIP_SIMULATION_MAIN
so that this package can have no dependancies
on Simulation Code.
07-Mar-2013 pkoduri 115.17 16451278 Replaced orgId with BG Id for determinig the
display of RATE DETAILS section on PDF Payslip.
*****************************************************************************/
g_proc_name varchar2(50);
SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name,
end_user_column_name segment_name
FROM fnd_descr_flex_col_usage_vl
WHERE descriptive_flexfield_name = p_flexfield_name
AND descriptive_flex_context_code = p_context_code
AND application_column_name = UPPER (p_node)
AND application_id = 801; /* Bug 6522667 */
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 TRANSLATE (UPPER(seg.segment_name), ' /','__')
FROM fnd_id_flex_structures_vl ctx,
fnd_id_flex_segments_vl seg
WHERE ctx.id_flex_num = seg.id_flex_num
AND ctx.id_flex_code = seg.id_flex_code
AND seg.id_flex_code = 'BANK'
AND ctx.id_flex_structure_code = p_id_flex_structure_code
AND seg.application_column_name = UPPER(p_node);
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 application_id = 801 /* Bug 6522667 */
AND enabled_flag = 'Y';
SELECT hoi2.org_information9
FROM pay_assignment_actions paa,
pay_payroll_actions ppa,
hr_organization_units hou,
hr_organization_information hoi1,
hr_organization_information hoi2
WHERE paa.payroll_action_id = ppa.payroll_action_id
AND ppa.business_group_id = hou.organization_id
AND hou.organization_id = hoi1.organization_id
AND hoi1.organization_id = hoi2.organization_id
AND ppa.effective_date BETWEEN hou.date_from
AND nvl(hou.date_to,
hr_general.end_of_time)
AND hoi1.org_information_context = 'CLASS'
AND hoi1.org_information1 = 'HR_BG'
AND hoi2.org_information_context = 'Business Group Information'
AND ppa.action_type = 'X'
AND NVL (p_action_context_id, (SELECT action_context_id
FROM pay_action_information
WHERE action_information_id =
p_action_information_id))
= paa.assignment_action_id;
SELECT DISTINCT action_information_category
FROM pay_action_information
WHERE ((action_context_type = 'AAP'
AND action_context_id = p_action_context_id)
OR (action_context_type = 'PA'
AND action_context_id =
(SELECT payroll_action_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_action_context_id)))
OR (action_information_id = p_action_information_id
AND p_action_information_id IS NOT NULL)
ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);
SELECT business_group_id
FROM pay_payroll_actions ppa,
pay_assignment_actions paa
WHERE
paa.payroll_action_id = ppa.payroll_action_id
AND paa.assignment_action_id=cp_assgn_action_id;
g_xml_table.delete();
SELECT DECODE (p_action_information_id,
NULL, 'NULL',
to_char(p_action_information_id)),
DECODE (p_action_context_id,
NULL, 'NULL',
to_char(p_action_context_id))
INTO l_action_information_id,
l_action_context_id
FROM DUAL;
' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||
'WHERE hle.information_type = ''HR_SELF_SERVICE_LOC_PREFERENCE''');
' SELECT NVL((select org_information13 FROM hr_organization_information '||
'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
' SELECT NVL((select org_information13 FROM hr_organization_information '||
'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
g_xml_table.delete();
pay_payroll_xml_extract_pkg.g_custom_params.delete(
pay_payroll_xml_extract_pkg.g_custom_params.last());
pay_payroll_xml_extract_pkg.g_custom_params.delete(
pay_payroll_xml_extract_pkg.g_custom_params.last());
SELECT hoi2.org_information9
FROM pay_assignment_actions paa,
pay_payroll_actions ppa,
hr_organization_units hou,
hr_organization_information hoi1,
hr_organization_information hoi2
WHERE paa.payroll_action_id = ppa.payroll_action_id
AND ppa.business_group_id = hou.organization_id
AND hou.organization_id = hoi1.organization_id
AND hoi1.organization_id = hoi2.organization_id
AND ppa.effective_date BETWEEN hou.date_from
AND nvl(hou.date_to,
hr_general.end_of_time)
AND hoi1.org_information_context = 'CLASS'
AND hoi1.org_information1 = 'HR_BG'
AND hoi2.org_information_context = 'Business Group Information'
AND ppa.action_type = 'X'
AND NVL (p_action_context_id, (SELECT action_context_id
FROM pay_action_information
WHERE action_information_id =
p_action_information_id))
= paa.assignment_action_id;
SELECT DISTINCT action_information_category
FROM pay_action_information
WHERE ((action_context_type = 'AAP'
AND action_context_id = p_action_context_id)
OR (action_context_type = 'PA'
AND action_context_id =
(SELECT payroll_action_id
FROM pay_assignment_actions
WHERE assignment_action_id = p_action_context_id)))
OR (action_information_id = p_action_information_id
AND p_action_information_id IS NOT NULL)
ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);
g_xml_table.delete();
SELECT DECODE (p_action_information_id,
NULL, 'NULL',
to_char(p_action_information_id)),
DECODE (p_action_context_id,
NULL, 'NULL',
to_char(p_action_context_id)),
DECODE (p_pre_payment_id,
NULL, 'NULL',
to_char(p_pre_payment_id))
INTO l_action_information_id,
l_action_context_id,
l_pre_payment_id
FROM DUAL;
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
g_xml_table.delete();