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_NO_ARC_RSEA_07 dependencies on PAY_ACTION_INFORMATION

Line 716: FROM pay_action_information

712: --
713: IF l_archive = 'Y' THEN
714: --
715: SELECT count(*) INTO l_count
716: FROM pay_action_information
717: WHERE action_context_id = p_payroll_action_id
718: AND action_context_type = 'PA'
719: AND action_information_category = 'EMEA REPORT INFORMATION'
720: AND action_information1 = 'PYNORSEA';

Line 806: pay_action_information_api.create_action_information (

802: l_el_a := greatest(l_el_a, 0);
803: l_el_b := greatest(l_el_b, 0);
804: --
805: /* Inserting header details belonging to Employer*/
806: pay_action_information_api.create_action_information (
807: p_action_information_id => l_action_info_id
808: ,p_action_context_id => p_payroll_action_id
809: ,p_action_context_type => 'PA'
810: ,p_object_version_number => l_ovn

Line 840: pay_action_information_api.create_action_information (

836: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
837: );
838: --
839: /* Inserting the selection criteria for generating the report*/
840: pay_action_information_api.create_action_information (
841: p_action_information_id => l_action_info_id
842: ,p_action_context_id => p_payroll_action_id
843: ,p_action_context_type => 'PA'
844: ,p_object_version_number => l_ovn

Line 1025: pay_action_information_api.create_action_information (

1021: l_tax_value := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1022: l_sum_tax_value := l_sum_tax_value + l_tax_value;
1023: END IF;
1024: --
1025: pay_action_information_api.create_action_information (
1026: p_action_information_id => l_action_info_id
1027: ,p_action_context_id => p_payroll_action_id
1028: ,p_action_context_type => 'PA'
1029: ,p_object_version_number => l_ovn

Line 1135: pay_action_information_api.create_action_information (

1131: -- EC Base Pension
1132: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1133: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1134: --
1135: pay_action_information_api.create_action_information (
1136: p_action_information_id => l_action_info_id
1137: ,p_action_context_id => p_payroll_action_id
1138: ,p_action_context_type => 'PA'
1139: ,p_object_version_number => l_ovn

Line 1238: pay_action_information_api.create_action_information (

1234: -- EC Base Pension
1235: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1236: l_pension_base := pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE);
1237: --
1238: pay_action_information_api.create_action_information (
1239: p_action_information_id => l_action_info_id
1240: ,p_action_context_id => p_payroll_action_id
1241: ,p_action_context_type => 'PA'
1242: ,p_object_version_number => l_ovn

Line 1381: FROM pay_action_information leg_emp

1377: ,leg_emp.action_information19 nace_code
1378: ,leg_emp.action_information20 ada_line3
1379: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1380: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1381: FROM pay_action_information leg_emp
1382: WHERE leg_emp.action_context_type = 'PA'
1383: AND leg_emp.action_context_id = l_payroll_action_id
1384: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
1385: AND leg_emp.action_information1 = 'PYNORSEA';

Line 1406: FROM pay_action_information lu

1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1406: FROM pay_action_information lu
1407: WHERE lu.action_context_type = 'PA'
1408: AND lu.action_context_id = l_payroll_action_id
1409: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
1410: AND lu.action_information1 = 'PYNORSEA-EC'

Line 1419: FROM pay_action_information wt

1415: CURSOR csr_TAX (l_payroll_action_id IN NUMBER) IS
1416: SELECT wt.action_information2 wt_municipal_num
1417: ,wt.action_information3 wt_municipal_name
1418: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value
1419: FROM pay_action_information wt
1420: WHERE wt.action_context_type = 'PA'
1421: AND wt.action_context_id = l_payroll_action_id
1422: AND wt.action_information_category = 'EMEA REPORT INFORMATION'
1423: AND wt.action_information1 = 'PYNORSEA-WT'

Line 1887: FROM pay_action_information leg_emp

1883: ,leg_emp.action_information19 nace_code
1884: ,leg_emp.action_information20 add_line3
1885: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1886: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1887: FROM pay_action_information leg_emp
1888: WHERE leg_emp.action_context_type = 'PA'
1889: AND leg_emp.action_context_id = l_payroll_action_id
1890: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
1891: AND leg_emp.action_information1 = 'PYNORSEA';

Line 1907: FROM pay_action_information lu

1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum
1907: FROM pay_action_information lu
1908: WHERE lu.action_context_type = 'PA'
1909: AND lu.action_context_id = l_payroll_action_id
1910: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
1911: AND lu.action_information1 = 'PYNORSEA-EC';

Line 1922: FROM pay_action_information lu

1918: ,lu.action_information5 lu_municipal_num
1919: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1920: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1921: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
1922: FROM pay_action_information lu
1923: WHERE lu.action_context_type = 'PA'
1924: AND lu.action_context_id = l_payroll_action_id
1925: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
1926: AND lu.action_information1 = 'PYNORSEA-EC'

Line 1935: FROM pay_action_information wt

1931: CURSOR csr_TAX
1932: (l_payroll_action_id IN NUMBER) IS
1933: SELECT wt.action_information2 wt_municipal_num
1934: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value
1935: FROM pay_action_information wt
1936: WHERE wt.action_context_type = 'PA'
1937: AND wt.action_context_id = l_payroll_action_id
1938: AND wt.action_information_category = 'EMEA REPORT INFORMATION'
1939: AND wt.action_information1 = 'PYNORSEA-WT'