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_AU_RECON_SUMMARY dependencies on PAY_PAYROLL_ACTIONS

Line 29: *** 09-OCT-03 Ragvoind 115.20 Bug#3034189 - Removed the usage of index INDEX(rppa pay_payroll_actions_pk) from cursor c_asgids.

25: *** If single Lump sum E payment is less than 400, then the amount is subtracted from Lump sum E.
26: *** 21 Aug 03 punmehta 115.18 Bug#3095923 - Modified the Cursor c_get_pay_earned_date to fetch effective_date instead of date_earned
27: *** 22-AUG-03 punmehta 115.19 Bug#3095923 - Modified the Cursor name c_get_pay_earned_date
28: *** to c_get_pay_effective_date and variable name of date_earned to effective_date
29: *** 09-OCT-03 Ragvoind 115.20 Bug#3034189 - Removed the usage of index INDEX(rppa pay_payroll_actions_pk) from cursor c_asgids.
30: *** 20-OCT-03 punmehta 115.21 Bug#3193479 - Implemented Batch Balance Retrieval. for that created new function to populate
31: *** global plsql table and other functions gets the balance value from this function.
32: *** 21-OCT-03 punmehta 115.22 Bug#3193479 - Added check for g_debug before tracing
33: *** 21-OCT-03 punmehta 115.23 Bug#3193479 - Modified OUT with OUT NOCOPY

Line 188: ,pay_payroll_actions ppa

184: ,pay_balance_types pbt
185: ,pay_defined_balances pdb
186: ,pay_balance_dimensions pbd
187: -- ,per_periods_of_service pps
188: ,pay_payroll_actions ppa
189: ,pay_assignment_actions pac
190: ,pay_run_results prr
191: WHERE pac.assignment_id = c_assignment_id
192: AND pac.tax_unit_id = c_registered_employer --2610141

Line 229: ,pay_payroll_actions ppa

225: IS
226: SELECT /*+ ORDERED */
227: DISTINCT pet.element_information2 balance_type_id
228: FROM per_all_assignments_f paf
229: ,pay_payroll_actions ppa
230: ,pay_assignment_actions paa
231: ,pay_run_results prr
232: ,pay_element_types_f pet
233: WHERE paa.assignment_id = c_assignment_id

Line 400: , pay_payroll_actions ppa

396: c_year_start date,
397: c_year_end date ) is
398: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) assignment_action_id
399: from pay_assignment_actions paa
400: , pay_payroll_actions ppa
401: , per_assignments_f paf
402: where paa.assignment_id = paf.assignment_id
403: and paf.assignment_id = c_assignment_id
404: and ppa.payroll_action_id = paa.payroll_action_id

Line 608: pay_payroll_Actions ppa,

604: ,v_year_end in DATE)
605: IS
606: select max(paa.assignment_action_id) /* Bug#3095923 , Bug 2610141*/
607: from per_assignments_f paf,
608: pay_payroll_Actions ppa,
609: pay_assignment_Actions paa,
610: per_time_periods ptp
611: where ppa.payroll_Action_id = paa.payroll_Action_id
612: and paa.assignment_id = v_assignment_id

Line 880: ,p_year_start in pay_payroll_Actions.effective_date%type

876:
877: function etp_details
878: (
879: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
880: ,p_year_start in pay_payroll_Actions.effective_date%type
881: ,p_year_end in pay_payroll_Actions.effective_date%type)
882: return number is
883:
884: e_prepost_error EXCEPTION;

Line 881: ,p_year_end in pay_payroll_Actions.effective_date%type)

877: function etp_details
878: (
879: p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
880: ,p_year_start in pay_payroll_Actions.effective_date%type
881: ,p_year_end in pay_payroll_Actions.effective_date%type)
882: return number is
883:
884: e_prepost_error EXCEPTION;
885:

Line 904: c_lst_year_start in pay_payroll_actions.effective_date%type,

900: l_lst_yr_start date;
901:
902:
903: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,
904: c_lst_year_start in pay_payroll_actions.effective_date%type,
905: c_year_start in pay_payroll_actions.effective_date%type,
906: c_year_end in pay_payroll_actions.effective_date%type
907: )is
908: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag

Line 905: c_year_start in pay_payroll_actions.effective_date%type,

901:
902:
903: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,
904: c_lst_year_start in pay_payroll_actions.effective_date%type,
905: c_year_start in pay_payroll_actions.effective_date%type,
906: c_year_end in pay_payroll_actions.effective_date%type
907: )is
908: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
909: ,actual_termination_date

Line 906: c_year_end in pay_payroll_actions.effective_date%type

902:
903: CURSOR etp_code(c_assignment_id in pay_assignment_actions.assignment_id%type,
904: c_lst_year_start in pay_payroll_actions.effective_date%type,
905: c_year_start in pay_payroll_actions.effective_date%type,
906: c_year_end in pay_payroll_actions.effective_date%type
907: )is
908: SELECT distinct nvl(current_employee_flag,'N') current_employee_flag
909: ,actual_termination_date
910: ,date_start

Line 1219: pay_payroll_actions paas

1215: is
1216: SELECT distinct paat.assignment_id
1217: from pay_action_interlocks pail,
1218: pay_assignment_actions paat,
1219: pay_payroll_actions paas
1220: where paat.assignment_id = c_assignment_id
1221: and paas.action_type ='X'
1222: and paas.action_status ='C'
1223: and paas.report_type ='AU_PAYMENT_SUMMARY_REPORT'

Line 1585: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1581: -- of assignments eligible for archival.
1582: --------------------------------------------------------------------
1583:
1584: procedure range_code
1585: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1586: p_sql out nocopy varchar2) is
1587: begin
1588: g_debug := hr_utility.debug_enabled;
1589: IF g_debug THEN

Line 1594: ' pay_payroll_actions pa' ||

1590: hr_utility.set_location('Start of range_code',1);
1591: END if;
1592: p_sql := ' select distinct p.person_id' ||
1593: ' from per_people_f p,' ||
1594: ' pay_payroll_actions pa' ||
1595: ' where pa.payroll_action_id = :payroll_action_id' ||
1596: ' and p.business_group_id = pa.business_group_id' ||
1597: ' order by p.person_id';
1598: IF g_debug THEN

Line 1612: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

1608: -- no archival is required.
1609: --------------------------------------------------------------------
1610:
1611: procedure initialization_code
1612: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
1613: begin
1614: NULL;
1615: END;
1616:

Line 1705: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

1701: -- It inserts the record in pay_assignment_Actions
1702: -- Which are then used in main report query to get assignment_ids
1703: --------------------------------------------------------------------
1704: procedure assignment_action_code
1705: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
1706: p_start_person_id in per_all_people_f.person_id%type,
1707: p_end_person_id in per_all_people_f.person_id%type,
1708: p_chunk in number) is
1709:

Line 1746: from pay_payroll_actions

1742: ,decode(pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters),null,'%', pay_core_utils.get_parameter('ASSIGNMENT_ID',legislative_parameters)) Assignment_id
1743: ,decode(pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters),null,'%',pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters)) payroll_id
1744: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term /*Bug3661230*/
1745: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
1746: from pay_payroll_actions
1747: where payroll_action_id =c_payroll_Action_id;
1748:
1749: cursor next_action_id is
1750: select pay_assignment_actions_s.nextval

Line 1767: INDEX(rppa pay_payroll_actions_pk)

1763: p_lst_year_start date
1764: )
1765: is
1766: SELECT /*+ INDEX(pap per_people_f_pk)
1767: INDEX(rppa pay_payroll_actions_pk)
1768: INDEX(paa per_assignments_f_N12)
1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap

Line 1773: ,pay_payroll_actions rppa

1769: INDEX(pps per_periods_of_service_pk)
1770: */ paa.assignment_id
1771: from per_people_f pap
1772: ,per_assignments_f paa
1773: ,pay_payroll_actions rppa
1774: ,per_periods_of_service pps
1775: where rppa.payroll_action_id = p_payroll_action_id
1776: and pap.person_id between p_start_person_id and p_end_person_id
1777: and pap.person_id = paa.person_id

Line 1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

1791: and paa.payroll_id like p_payroll_id
1792: /* End of Bug: 3872211 */
1793: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1794: INDEX(rpac pay_assignment_actions_n1)
1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM
1798: pay_payroll_actions rppa
1799: ,pay_assignment_actions rpac

Line 1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''

1792: /* End of Bug: 3872211 */
1793: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1794: INDEX(rpac pay_assignment_actions_n1)
1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM
1798: pay_payroll_actions rppa
1799: ,pay_assignment_actions rpac
1800: ,per_assignments_f paaf -- Bug: 3872211

Line 1798: pay_payroll_actions rppa

1794: INDEX(rpac pay_assignment_actions_n1)
1795: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1796: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1797: FROM
1798: pay_payroll_actions rppa
1799: ,pay_assignment_actions rpac
1800: ,per_assignments_f paaf -- Bug: 3872211
1801: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1802: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */

Line 1844: INDEX(rppa pay_payroll_actions_pk)

1840: p_lst_year_start date
1841: )
1842: IS
1843: SELECT /*+ INDEX(pap per_people_f_pk)
1844: INDEX(rppa pay_payroll_actions_pk)
1845: INDEX(ppr PAY_POPULATION_RANGES_N4)
1846: INDEX(paa per_assignments_f_N12)
1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id

Line 1851: ,pay_payroll_actions rppa

1847: INDEX(pps per_periods_of_service_PK)
1848: */ paa.assignment_id
1849: from per_people_f pap
1850: ,per_assignments_f paa
1851: ,pay_payroll_actions rppa
1852: ,per_periods_of_service pps
1853: ,pay_population_ranges ppr
1854: where rppa.payroll_action_id = p_payroll_action_id
1855: and rppa.payroll_action_id = ppr.payroll_action_id

Line 1875: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

1871: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1872: and paa.payroll_id like p_payroll_id
1873: /* End of Bug: 3872211 */
1874: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1875: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)
1877: */''
1878: FROM
1879: pay_payroll_actions rppa

Line 1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)

1872: and paa.payroll_id like p_payroll_id
1873: /* End of Bug: 3872211 */
1874: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1875: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)
1877: */''
1878: FROM
1879: pay_payroll_actions rppa
1880: ,pay_assignment_actions rpac

Line 1879: pay_payroll_actions rppa

1875: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1876: INDEX(rppa PAY_PAYROLL_ACTIONS_PK)
1877: */''
1878: FROM
1879: pay_payroll_actions rppa
1880: ,pay_assignment_actions rpac
1881: ,per_assignments_f paaf -- Bug: 3872211
1882: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1883: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */

Line 1917: INDEX(rppa pay_payroll_actions_pk)

1913: is
1914: SELECT /*+ INDEX(pap per_people_f_pk)
1915: INDEX(paa per_assignments_f_fk1)
1916: INDEX(paa per_assignments_f_N12)
1917: INDEX(rppa pay_payroll_actions_pk)
1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa

Line 1922: ,pay_payroll_actions rppa

1918: INDEX(pps per_periods_of_service_n3)
1919: */ distinct paa.assignment_id
1920: from per_people_f pap
1921: ,per_assignments_f paa
1922: ,pay_payroll_actions rppa
1923: ,per_periods_of_service pps
1924: where rppa.payroll_action_id = p_payroll_action_id
1925: and pap.person_id between p_start_person_id and p_end_person_id
1926: and pap.person_id = paa.person_id

Line 1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)

1940: AND iipaf.payroll_id IS NOT NULL) /* Bug#4688800 */
1941: and paa.payroll_id like p_payroll_id
1942: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1943: INDEX(rpac pay_assignment_actions_n1)
1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM
1947: pay_payroll_actions rppa
1948: ,pay_assignment_actions rpac

Line 1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''

1941: and paa.payroll_id like p_payroll_id
1942: AND EXISTS (SELECT /*+ INDEX(rpac PAY_ASSIGNMENT_ACTIONS_N51)
1943: INDEX(rpac pay_assignment_actions_n1)
1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM
1947: pay_payroll_actions rppa
1948: ,pay_assignment_actions rpac
1949: ,per_assignments_f paaf -- Bug: 3872211

Line 1947: pay_payroll_actions rppa

1943: INDEX(rpac pay_assignment_actions_n1)
1944: INDEX(rppa PAY_PAYROLL_ACTIONS_N51)
1945: INDEX(rppa PAY_PAYROLL_ACTIONS_PK) */''
1946: FROM
1947: pay_payroll_actions rppa
1948: ,pay_assignment_actions rpac
1949: ,per_assignments_f paaf -- Bug: 3872211
1950: where (rppa.effective_date between p_fin_year_start and p_fin_year_end /*Bug3048962 */
1951: or ( pps.actual_termination_date between p_lst_fbt_yr_start and p_fbt_year_end /*Bug3263659 */

Line 2199: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

2195: -- And the report displays detials for all the archived assignments.
2196: --------------------------------------------------------------------
2197:
2198: PROCEDURE spawn_ps_report
2199: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
2200:
2201: ps_request_id NUMBER;
2202: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2203: l_business_group_id number;

Line 2202: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

2198: PROCEDURE spawn_ps_report
2199: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
2200:
2201: ps_request_id NUMBER;
2202: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
2203: l_business_group_id number;
2204: l_start_date date;
2205: l_end_date date;
2206: l_effective_date date;

Line 2227: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)

2223: -- Description : Fetches User Parameters from Legislative_paramters
2224: -- column.
2225: --------------------------------------------------------------------+
2226:
2227: CURSOR csr_report_params(c_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE)
2228: IS
2229: select pay_core_utils.get_parameter('FINANCIAL_YEAR',legislative_parameters) Financial_year
2230: ,pay_core_utils.get_parameter('EMPLOYEE_TYPE',legislative_parameters) Employee_type
2231: ,pay_core_utils.get_parameter('REGISTERED_EMPLOYER',legislative_parameters) legal_employer

Line 2237: from pay_payroll_actions

2233: ,pay_core_utils.get_parameter('PAYROLL_ID',legislative_parameters) payroll_id
2234: ,pay_core_utils.get_parameter('LST_YR_TERM',legislative_parameters) lst_yr_term
2235: ,pay_core_utils.get_parameter('BUSINESS_GROUP_ID',legislative_parameters) Business_group_id
2236: ,pay_core_utils.get_parameter('OUTPUT_TYPE',legislative_parameters)p_output_type /* Bug# 6839263 */
2237: from pay_payroll_actions
2238: where payroll_action_id =c_payroll_Action_id;
2239:
2240:
2241:

Line 2247: FROM pay_payroll_actions pact,

2243: SELECT printer,
2244: print_style,
2245: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
2246: ,number_of_copies /* Bug 4116833 */
2247: FROM pay_payroll_actions pact,
2248: fnd_concurrent_requests fcr
2249: WHERE fcr.request_id = pact.request_id
2250: AND pact.payroll_action_id = p_payroll_action_id;
2251: