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 787: FROM pay_action_information

783: --
784: IF l_archive = 'Y' THEN
785: --
786: SELECT count(*) INTO l_count
787: FROM pay_action_information
788: WHERE action_context_id = p_payroll_action_id
789: AND action_context_type = 'PA'
790: AND action_information_category = 'EMEA REPORT INFORMATION'
791: AND action_information1 = 'PYNORSEA';

Line 885: pay_action_information_api.create_action_information (

881: CLOSE csr_get_mun_dtls;
882: --14260836
883:
884: /* Inserting header details belonging to Employer*/
885: pay_action_information_api.create_action_information (
886: p_action_information_id => l_action_info_id
887: ,p_action_context_id => p_payroll_action_id
888: ,p_action_context_type => 'PA'
889: ,p_object_version_number => l_ovn

Line 922: pay_action_information_api.create_action_information (

918: ,p_action_information25 => rg_get_mun_dtls1.municipal_name --14260836
919: );
920: --
921: /* Inserting the selection criteria for generating the report*/
922: pay_action_information_api.create_action_information (
923: p_action_information_id => l_action_info_id
924: ,p_action_context_id => p_payroll_action_id
925: ,p_action_context_type => 'PA'
926: ,p_object_version_number => l_ovn

Line 1111: pay_action_information_api.create_action_information (

1107:
1108: l_sum_tax_value := FLOOR(l_sum_tax_value); --14260836
1109: l_sum_tax_value_rep := GREATEST(l_sum_tax_value,0); --14260836
1110: --
1111: pay_action_information_api.create_action_information (
1112: p_action_information_id => l_action_info_id
1113: ,p_action_context_id => p_payroll_action_id
1114: ,p_action_context_type => 'PA'
1115: ,p_object_version_number => l_ovn

Line 1235: pay_action_information_api.create_action_information (

1231: --14260836
1232: l_pension_amount := l_rate/100 * NVL(l_pension_base,0);
1233: l_base_amt := l_base_amt - l_pension_amount;
1234:
1235: pay_action_information_api.create_action_information (
1236: p_action_information_id => l_action_info_id
1237: ,p_action_context_id => p_payroll_action_id
1238: ,p_action_context_type => 'PA'
1239: ,p_object_version_number => l_ovn

Line 1359: pay_action_information_api.create_action_information (

1355: --14260836
1356: l_pension_amount := l_rate/100 * NVL(l_pension_base,0);
1357: l_base_amt := l_base_amt - l_pension_amount;
1358:
1359: pay_action_information_api.create_action_information (
1360: p_action_information_id => l_action_info_id
1361: ,p_action_context_id => p_payroll_action_id
1362: ,p_action_context_type => 'PA'
1363: ,p_object_version_number => l_ovn

Line 1507: FROM pay_action_information leg_emp

1503: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1504: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1505: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
1506: ,leg_emp.action_information25 municipal_name --14260836
1507: FROM pay_action_information leg_emp
1508: WHERE leg_emp.action_context_type = 'PA'
1509: AND leg_emp.action_context_id = l_payroll_action_id
1510: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
1511: AND leg_emp.action_information1 = 'PYNORSEA';

Line 1534: FROM pay_action_information lu

1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836
1534: FROM pay_action_information lu
1535: WHERE lu.action_context_type = 'PA'
1536: AND lu.action_context_id = l_payroll_action_id
1537: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
1538: AND lu.action_information1 = 'PYNORSEA-EC'

Line 1547: FROM pay_action_information wt

1543: CURSOR csr_TAX (l_payroll_action_id IN NUMBER) IS
1544: SELECT wt.action_information2 wt_municipal_num
1545: ,wt.action_information3 wt_municipal_name
1546: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836
1547: FROM pay_action_information wt
1548: WHERE wt.action_context_type = 'PA'
1549: AND wt.action_context_id = l_payroll_action_id
1550: AND wt.action_information_category = 'EMEA REPORT INFORMATION'
1551: AND wt.action_information1 = 'PYNORSEA-WT'

Line 1577: FROM pay_action_information lu

1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
1577: FROM pay_action_information lu
1578: WHERE lu.action_context_type = 'PA'
1579: AND lu.action_context_id = l_payroll_action_id
1580: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
1581: AND lu.action_information1 = 'PYNORSEA-EC'

Line 2117: FROM pay_action_information leg_emp

2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
2115: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
2116: ,fnd_number.canonical_to_number(leg_emp.action_information24) utl2_base -- Bug#9579261 fix
2117: FROM pay_action_information leg_emp
2118: WHERE leg_emp.action_context_type = 'PA'
2119: AND leg_emp.action_context_id = l_payroll_action_id
2120: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'
2121: AND leg_emp.action_information1 = 'PYNORSEA';

Line 2138: FROM pay_action_information lu

2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2138: FROM pay_action_information lu
2139: WHERE lu.action_context_type = 'PA'
2140: AND lu.action_context_id = l_payroll_action_id
2141: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
2142: AND lu.action_information1 = 'PYNORSEA-EC';

Line 2153: FROM pay_action_information lu

2149: ,lu.action_information5 lu_municipal_num
2150: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
2151: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
2152: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
2153: FROM pay_action_information lu
2154: WHERE lu.action_context_type = 'PA'
2155: AND lu.action_context_id = l_payroll_action_id
2156: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
2157: AND lu.action_information1 = 'PYNORSEA-EC'

Line 2166: FROM pay_action_information wt

2162: CURSOR csr_TAX
2163: (l_payroll_action_id IN NUMBER) IS
2164: SELECT wt.action_information2 wt_municipal_num
2165: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836
2166: FROM pay_action_information wt
2167: WHERE wt.action_context_type = 'PA'
2168: AND wt.action_context_id = l_payroll_action_id
2169: AND wt.action_information_category = 'EMEA REPORT INFORMATION'
2170: AND wt.action_information1 = 'PYNORSEA-WT'

Line 2214: FROM pay_action_information lu

2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2214: FROM pay_action_information lu
2215: WHERE lu.action_context_type = 'PA'
2216: AND lu.action_context_id = l_payroll_action_id
2217: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
2218: AND lu.action_information1 = 'PYNORSEA-EC'

Line 2237: FROM pay_action_information lu

2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
2237: FROM pay_action_information lu
2238: WHERE lu.action_context_type = 'PA'
2239: AND lu.action_context_id = l_payroll_action_id
2240: AND lu.action_information_category = 'EMEA REPORT INFORMATION'
2241: AND lu.action_information1 = 'PYNORSEA-EC'