[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
vmehta 05-Oct-2005 115.3 Delete the parameter table
pay_payroll_xml_extract_pkg.
g_custom_params before setting.
mmukherj 21-Oct-2005 115.4 Created another TAG in the
employee details level which
prints the deposit amount
multiplied by 100. This is needed
because the output format for some
legislations needs the deposit
amount printed that way. The name
of the new Tag is:
DEPOSIT_AMOUNT100.
vmehta 24-Oct-2005 115.5 Removed the new tag
DEPOSIT_AMOUNT100. Changed
AMOUNT to varchar. This is stored
in the '9999999999D99' format
to address the trailing zero issue
vmehta 20-Nov-2005 115.6 Modified gen_employer_level_xml
to fetch information about
Paymeth Developer DF and add to
XML
vmehta 21-Nov-2005 115.7 Add Paymeth Developer DF related
segments only if not null.
sdahiya 25-Nov-2005 115.8 4761066 Added FM to number format mask
to eliminate leading spaces.
sdahiya 30-Nov-2005 115.9 4773967 CLOB to BLOB migration.
sdahiya 01-Dec-2005 115.10 Modified PRINT_BLOB to use
pay_ac_utility.print_lob.
sdahiya 01-Dec-2005 115.11 Used core procedure
pay_core_files.write_to_magtape_lob
to manipulate core magtape BLOB.
sdahiya 22-Dec-2005 115.12 Removed XML header information.
PYUGEN will generate XML headers.
nragavar 30-Jan-2007 115.14 Reverted back to V115.12 as the changes
to V115.13 were wrongly done
jeisaac 06-Feb-2012 115.15 Made change in calling legislation specific
package
========================================================================*/
--
-- Global Variables
--
TYPE char_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
SELECT legislation_code
FROM per_business_groups
WHERE business_group_id = p_business_group_id;
SELECT segment1 ,segment2 ,segment3
,segment4 ,segment5 ,segment6 ,segment7
,segment8 ,segment9 ,segment10 ,segment11
,segment12 ,segment13 ,segment14 ,segment15
,segment16 ,segment17 ,segment18 ,segment19
,segment20 ,segment21 ,segment22 ,segment23
,segment24 ,segment25 ,segment26 ,segment27
,segment28 ,segment29 ,segment30 ,org_payment_method_id
FROM pay_personal_payment_methods_f pppm,
pay_external_accounts pea
WHERE --pppm.assignment_id = p_assignment_id
pppm.personal_payment_method_id = p_per_pay_method
AND pppm.external_account_id = pea.external_account_id
AND p_effective_date between pppm.EFFECTIVE_START_DATE
and pppm.EFFECTIVE_END_DATE;
SELECT ppf.first_name, ppf.last_name, ppf.middle_names, ppf.order_name,
ppf.full_name, ppf.national_identifier,
ppf.employee_number
FROM per_assignments_f paf,
per_all_people_f ppf,
per_periods_of_service pps
WHERE paf.person_id = ppf.person_id
and paf.assignment_id = p_assignment_id
and p_effective_date between paf.effective_start_date
and paf.effective_end_date
and p_effective_date between ppf.effective_start_date
and ppf.effective_end_date
and pps.person_id = ppf.person_id
and pps.date_start = (select max(pps1.date_start)
from per_periods_of_service pps1
where pps1.person_id = paf.person_id
and pps1.date_start <= p_effective_date);
SELECT ppa.start_date,ppa.effective_date,
pp.payroll_name
FROM pay_assignment_actions paa
,pay_payroll_actions ppa
,pay_payrolls_f pp
WHERE paa.assignment_action_id = p_prepay_asg_act
and ppa.payroll_action_id = paa.payroll_action_id
and pp.payroll_id = ppa.payroll_id
and ppa.effective_date between pp.effective_start_date
and pp.effective_end_date;
g_person_flex.delete;
pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
SELECT pay_ip_utility.get_ip_installation(ln_business_group_id)
INTO lv_legislation_install FROM dual;
pay_payroll_xml_extract_pkg.g_xml_table.delete();
SELECT segment1 ,segment2 ,segment3
,segment4 ,segment5 ,segment6 ,segment7
,segment8 ,segment9 ,segment10 ,segment11
,segment12 ,segment13 ,segment14 ,segment15
,segment16 ,segment17 ,segment18 ,segment19
,segment20 ,segment21 ,segment22 ,segment23
,segment24 ,segment25 ,segment26 ,segment27
,segment28 ,segment29 ,segment30 ,popm.currency_code
,pmeth_information_category
,pmeth_information1 ,pmeth_information2 ,pmeth_information3
,pmeth_information4 ,pmeth_information5 ,pmeth_information6
,pmeth_information7 ,pmeth_information8 ,pmeth_information9
,pmeth_information10 ,pmeth_information11 ,pmeth_information12
,pmeth_information13 ,pmeth_information14 ,pmeth_information15
,pmeth_information16 ,pmeth_information17 ,pmeth_information18
,pmeth_information19 ,pmeth_information20
FROM pay_org_payment_methods_f popm,
pay_external_accounts pea
WHERE org_payment_method_id = p_org_payment_method_id
AND popm.external_account_id = pea.external_account_id
AND p_effective_date between popm.EFFECTIVE_START_DATE
and popm.EFFECTIVE_END_DATE;
g_org_flex.delete;
g_pmeth_flex.delete;
pay_payroll_xml_extract_pkg.g_xml_table.delete();
pay_payroll_xml_extract_pkg.g_custom_params.DELETE;
SELECT pay_ip_utility.get_ip_installation(ln_business_group_id)
INTO lv_legislation_install FROM dual;