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.PAY_IE_P45_ARCHIVE dependencies on PAY_ACTION_INFORMATION

Line 332: pay_action_information_api.create_action_information (

328: hr_utility.set_location('p_effective_date = '||p_effective_date,20);
329: hr_utility.set_location('defined_balance_id = '||g_statutory_balance_table(l_index).defined_balance_id,20);
330: hr_utility.set_location('balance_name = '||g_statutory_balance_table(l_index).balance_name,20);
331:
332: pay_action_information_api.create_action_information (
333: p_action_information_id => l_action_info_id
334: , p_action_context_id => p_pactid
335: , p_action_context_type => 'PA'
336: , p_object_version_number => l_ovn

Line 782: from pay_action_information act_inf

778:
779: -- Fetch Commencement date when no previous p45 produced.
780: CURSOR comm_date_first IS
781: select act_inf.action_information11
782: from pay_action_information act_inf
783: where act_inf.action_context_id = p_assactid
784: and act_inf.action_information_category = 'EMPLOYEE DETAILS'
785: and act_inf.action_context_type = 'AAP';
786:

Line 790: from pay_action_information act_inf

786:
787: -- Fetch Commencement date when p45 is produced previously.
788: CURSOR comm_date_last_p45 IS
789: select act_inf.action_information30
790: from pay_action_information act_inf
791: where act_inf.action_context_id = p_last_p45_act
792: and act_inf.action_information_category = 'IE EMPLOYEE DETAILS'
793: and act_inf.action_context_type = 'AAP';
794:

Line 1222: pay_action_information_api.create_action_information (

1218: CLOSE comm_date_last_p45;
1219: end if;*/
1220: -- end bug 5383808
1221: hr_utility.set_location('Archiving IE EMPLOYEE DETAILS',50);
1222: pay_action_information_api.create_action_information (
1223: p_action_information_id => l_action_info_id
1224: , p_action_context_id => p_assactid
1225: , p_action_context_type => 'AAP'
1226: , p_object_version_number => l_ovn

Line 1437: FROM pay_action_information pai

1433:
1434: -- get balance from EMEA balances
1435: cursor get_prev_ins_bal is
1436: SELECT to_number(pai.action_information4) balance_value
1437: FROM pay_action_information pai
1438: WHERE pai.action_context_id = p_last_p45_action
1439: AND pai.action_information_category = 'EMEA BALANCES'
1440: AND pai.action_information1 = p_defined_bal_id;
1441:

Line 1799: pay_action_information_api.create_action_information (

1795:
1796: IF l_balance_value <> 0
1797: THEN
1798: hr_utility.set_location('Archiving EMEA BALANCES',20);
1799: pay_action_information_api.create_action_information (
1800: p_action_information_id => l_action_info_id
1801: , p_action_context_id => p_action_context_id
1802: , p_action_context_type => 'AAP'
1803: , p_object_version_number => l_ovn

Line 1849: FROM pay_action_information pai

1845: where defined_balance_id = p_defined_bal_id;
1846:
1847: CURSOR csr_get_curr_val(p_action_context_id NUMBER,p_def_bal_id NUMBER) IS
1848: SELECT to_number(pai.action_information4) balance_value
1849: FROM pay_action_information pai
1850: WHERE pai.action_context_id = p_action_context_id
1851: AND pai.action_information_category = 'EMEA BALANCES'
1852: AND pai.action_information1 = p_def_bal_id;
1853:

Line 1857: pay_action_information pai,

1853:
1854: -- cursor to fetch source_id from the last p45 action
1855: CURSOR get_last_source_id is
1856: select source_id from
1857: pay_action_information pai,
1858: pay_assignment_actions paa
1859: where paa.assignment_action_id = p_last_p45_action
1860: and paa.assignment_action_id = pai.action_context_id
1861: and pai.action_information_category='EMEA BALANCES';

Line 1927: pay_action_information_api.create_action_information (

1923: END IF;
1924: IF l_balance_value <> 0
1925: THEN
1926: hr_utility.set_location('Archiving EMEA BALANCES',20);
1927: pay_action_information_api.create_action_information (
1928: p_action_information_id => l_action_info_id
1929: , p_action_context_id => p_action_context_id
1930: , p_action_context_type => 'AAP'
1931: , p_object_version_number => l_ovn

Line 2015: pay_action_information act_inf

2011: from pay_assignment_actions paa_run,
2012: pay_action_interlocks pai,
2013: pay_assignment_actions paa,
2014: pay_payroll_actions ppa,
2015: pay_action_information act_inf
2016: where ppa.payroll_action_id = paa.payroll_action_id
2017: and ppa.report_type = 'P45'
2018: and ppa.report_qualifier = 'IE'
2019: and ppa.action_type = 'X'

Line 2250: from pay_action_information pai,

2246: and result_value not in ('IE_CUMULATIVE', 'C','IE_EXEMPTION');
2247: /*
2248: cursor cur_supp_run is
2249: select count(*)
2250: from pay_action_information pai,
2251: pay_assignment_Actions paa
2252: where paa.assignment_action_id = pai.action_context_id
2253: and pai.action_context_type = 'AAP'
2254: and pai.action_information_category = 'IE P45 INFORMATION'

Line 2270: pay_action_information act_inf

2266: from pay_assignment_actions paa_run,
2267: pay_action_interlocks pai,
2268: pay_assignment_actions paa,
2269: pay_payroll_actions ppa,
2270: pay_action_information act_inf
2271: where ppa.payroll_action_id = paa.payroll_action_id
2272: and ppa.report_type = 'P45'
2273: and ppa.report_qualifier = 'IE'
2274: and ppa.action_type = 'X'

Line 2475: pay_action_information_api.create_action_information (

2471: -- CLOSE cur_cal_option;
2472: hr_utility.set_location('non cum basis operated = '||l_noncum_ben_operated,20);
2473: --
2474: -- archive the details
2475: pay_action_information_api.create_action_information (
2476: p_action_information_id => l_action_info_id
2477: , p_action_context_id => p_action_context_id
2478: , p_action_context_type => 'AAP'
2479: , p_object_version_number => l_ovn

Line 2511: FROM pay_action_information pai

2507: CURSOR csr_check_archived(p_pact_id NUMBER) IS
2508: SELECT 1
2509: FROM DUAL
2510: WHERE EXISTS (SELECT NULL
2511: FROM pay_action_information pai
2512: WHERE pai.action_context_id = p_pact_id
2513: AND pai.action_context_type = 'PA'
2514: AND rownum = 1
2515: );

Line 2630: FROM pay_action_information pai

2626: AND cp_effective_date between paf.effective_start_date
2627: AND paf.effective_end_date
2628: AND NOT EXISTS (
2629: SELECT NULL
2630: FROM pay_action_information pai
2631: WHERE pai.action_context_id = cp_payroll_action_id
2632: AND pai.action_context_type = 'PA'
2633: AND pai.action_information_category = 'ADDRESS DETAILS'
2634: AND pai.action_information1 = paf.organization_id

Line 2718: pay_action_information_api.create_action_information (

2714: else
2715: */
2716: FOR tax_info_rec IN csr_get_org_tax_address (g_paye_ref) LOOP
2717: --
2718: pay_action_information_api.create_action_information (
2719: p_action_information_id => l_action_info_id
2720: , p_action_context_id => p_payroll_action_id
2721: , p_action_context_type => 'PA'
2722: , p_object_version_number => l_ovn

Line 2759: pay_action_information_api.create_action_information (

2755: hr_utility.set_location('rec_payroll_info.payroll_action_id = ' || rec_payroll_info.payroll_action_id,30);
2756: hr_utility.set_location('rec_payroll_info.tax_details_ref = ' || rec_payroll_info.tax_details_ref_no,30);
2757: hr_utility.set_location('rec_payroll_info.employers_paye_ref_no = ' || rec_payroll_info.employer_paye_ref_no,30);
2758: hr_utility.set_location('Archiving EMEA PAYROLL INFO',30);
2759: pay_action_information_api.create_action_information (
2760: p_action_information_id => l_action_info_id
2761: , p_action_context_id => p_payroll_action_id
2762: , p_action_context_type => 'PA'
2763: , p_object_version_number => l_ovn

Line 3230: pay_action_information pai_p45,

3226: ) IS
3227: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
3228: FROM pay_payroll_actions ppa_p45,
3229: pay_assignment_actions p45_src,
3230: pay_action_information pai_p45,
3231: pay_assignment_actions paa_src
3232: WHERE ppa_p45.action_type = 'X'
3233: AND ppa_p45.report_type = 'P45'
3234: AND ppa_p45.report_qualifier = 'IE'

Line 3252: pay_action_information pai

3248: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3249: paa.assignment_action_id),16))
3250: FROM pay_payroll_actions ppa,
3251: pay_assignment_actions paa,
3252: pay_action_information pai
3253: WHERE paa.assignment_action_id = pai.action_context_id
3254: AND pai.action_information_category = 'IE P45 INFORMATION'
3255: AND pai.action_context_type = 'AAP'
3256: AND paa.tax_unit_id = g_paye_ref

Line 3570: FROM pay_action_information pai1

3566: CURSOR csr_get_def_bal(p_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE
3567: ,p_balance_name pay_balance_types.balance_name%TYPE
3568: ) IS
3569: SELECT pai1.action_information2
3570: FROM pay_action_information pai1
3571: WHERE pai1.action_context_type = 'PA'
3572: AND pai1.action_information_category = 'EMEA BALANCE DEFINITION'
3573: AND substr(pai1.action_information4, 1,50) = p_balance_name
3574: AND pai1.action_context_id = p_payroll_action_id;

Line 3577: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS

3573: AND substr(pai1.action_information4, 1,50) = p_balance_name
3574: AND pai1.action_context_id = p_payroll_action_id;
3575:
3576: CURSOR csr_get_arc_bal_value(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
3577: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS
3578: SELECT to_number(pai2.action_information4) balance_value
3579: FROM pay_action_information pai2
3580: WHERE pai2.action_context_id = p_assignment_action_id
3581: AND pai2.action_information_category = 'EMEA BALANCES'

Line 3579: FROM pay_action_information pai2

3575:
3576: CURSOR csr_get_arc_bal_value(p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE
3577: ,p_def_bal_id pay_action_information.action_information1%TYPE) IS
3578: SELECT to_number(pai2.action_information4) balance_value
3579: FROM pay_action_information pai2
3580: WHERE pai2.action_context_id = p_assignment_action_id
3581: AND pai2.action_information_category = 'EMEA BALANCES'
3582: AND pai2.action_context_type = 'AAP'
3583: AND pai2.action_information1 = p_def_bal_id;

Line 3586: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;

3582: AND pai2.action_context_type = 'AAP'
3583: AND pai2.action_information1 = p_def_bal_id;
3584:
3585: l_bal_value number:=null;
3586: l_def_bal_id pay_action_information.action_information1%TYPE := NULL;
3587:
3588: BEGIN
3589:
3590: --hr_utility.trace_on(null,'P45XML');

Line 3661: FROM pay_action_information pai_ed

3657: ,(round(to_number(emp_supp.lump_sum),2)*100) supp_lumpsum
3658: ,(round(to_number(emp_supp.total_prsi),2)*100) supp_totalprsi
3659: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
3660: ,emp_supp.insurable_weeks supp_totalweeks
3661: FROM pay_action_information pai_ed
3662: ,pay_action_information pai_iep45
3663: ,pay_action_information pai_ieed
3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa

Line 3662: ,pay_action_information pai_iep45

3658: ,(round(to_number(emp_supp.total_prsi),2)*100) supp_totalprsi
3659: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
3660: ,emp_supp.insurable_weeks supp_totalweeks
3661: FROM pay_action_information pai_ed
3662: ,pay_action_information pai_iep45
3663: ,pay_action_information pai_ieed
3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa
3666: ,pay_action_interlocks pai_arc

Line 3663: ,pay_action_information pai_ieed

3659: ,(round(to_number(emp_supp.total_employee_prsi),2)*100) supp_employeeprsi
3660: ,emp_supp.insurable_weeks supp_totalweeks
3661: FROM pay_action_information pai_ed
3662: ,pay_action_information pai_iep45
3663: ,pay_action_information pai_ieed
3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa
3666: ,pay_action_interlocks pai_arc
3667: ,pay_assignment_actions paa_payroll

Line 3664: ,pay_action_information pai_epif

3660: ,emp_supp.insurable_weeks supp_totalweeks
3661: FROM pay_action_information pai_ed
3662: ,pay_action_information pai_iep45
3663: ,pay_action_information pai_ieed
3664: ,pay_action_information pai_epif
3665: ,pay_assignment_actions paa
3666: ,pay_action_interlocks pai_arc
3667: ,pay_assignment_actions paa_payroll
3668: ,per_time_periods ptp

Line 3711: FROM pay_action_information pai_ed

3707: ,decode(ptp.period_type,'Lunar Month','W',decode(instr(ptp.period_type,'Week'),0,'M','W')) freq
3708: ,to_number(substr(pai_iep45.action_information5, 1,30)) period
3709: ,pai_iep45.action_information4 emergency_tax,
3710: to_date(substr(pai_iep45.action_information7, 1,30),'DD/MM/RRRR') date_paid --Bug 3991416
3711: FROM pay_action_information pai_ed
3712: ,pay_action_information pai_iep45
3713: ,pay_assignment_actions paa
3714: ,per_time_periods ptp
3715: WHERE paa.payroll_action_id = c_p45_arch_id

Line 3712: ,pay_action_information pai_iep45

3708: ,to_number(substr(pai_iep45.action_information5, 1,30)) period
3709: ,pai_iep45.action_information4 emergency_tax,
3710: to_date(substr(pai_iep45.action_information7, 1,30),'DD/MM/RRRR') date_paid --Bug 3991416
3711: FROM pay_action_information pai_ed
3712: ,pay_action_information pai_iep45
3713: ,pay_assignment_actions paa
3714: ,per_time_periods ptp
3715: WHERE paa.payroll_action_id = c_p45_arch_id
3716: AND paa.assignment_action_id = pai_iep45.action_context_id

Line 3731: ,pay_action_information pai_epif

3727: SELECT pai_epif.action_information6 employer_number
3728: FROM pay_assignment_actions paa
3729: ,pay_action_interlocks pai_arc
3730: ,pay_assignment_actions paa_payroll
3731: ,pay_action_information pai_epif
3732: WHERE paa.assignment_action_id = p_assignment_action_id
3733: AND paa.assignment_action_id = pai_arc.locking_action_id
3734: AND paa_payroll.assignment_action_id = pai_arc.locked_action_id
3735: AND paa.payroll_action_id = pai_epif.action_context_ID

Line 3744: FROM pay_action_information pai_ieed

3740: CURSOR cur_p45_ie_emp_details (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
3741: SELECT (round(to_number(substr(nvl(pai_ieed.action_information26,'0'), 1,30)),2)*100) taxcredit
3742: ,(round(to_number(substr(nvl(pai_ieed.action_information27,'0'), 1,30)),2)*100) cutoff
3743: ,substr(pai_ieed.action_information22, 1,30) prsi_class
3744: FROM pay_action_information pai_ieed
3745: WHERE pai_ieed.action_context_ID = p_assignment_action_id
3746: AND pai_ieed.action_context_type = 'AAP'
3747: AND pai_ieed.action_information_category = 'IE EMPLOYEE DETAILS';
3748: cur_p45_ie_emp_details_rec cur_p45_ie_emp_details%ROWTYPE;

Line 3836: FROM pay_action_information pai

3832: ,substr(pai.action_information7,1,30) employer_tax_addr3
3833: ,substr(pai.action_information26,1,30) employer_tax_contact
3834: ,substr(pai.action_information27,1,12) employer_tax_ref_phone
3835: ,substr(pai.action_information28,1,30) employer_tax_rep_name
3836: FROM pay_action_information pai
3837: WHERE pai.action_context_id = c_payroll_action_id
3838: AND pai.action_context_type = 'PA'
3839: AND pai.action_information_category = 'ADDRESS DETAILS'
3840: AND pai.action_information14 = 'IE Employer Tax Address';