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_CESS_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 145: pay_assignment_actions paa,

141: from per_periods_of_service ppos
142: where ppos.person_id = p_person_id
143: and ppos.period_of_service_id = (select max(paf.period_of_service_id)
144: from per_all_assignments_f paf,
145: pay_assignment_actions paa,
146: pay_action_interlocks pai
147: where pai.locking_action_id = p_action_context_id
148: and pai.locked_action_id = paa.assignment_action_id
149: and paa.action_status = 'C'

Line 183: from pay_assignment_actions paa_run,

179:
180:
181: cursor cur_supp_run is
182: select fnd_date.canonical_to_date(act_inf.action_information3)
183: from pay_assignment_actions paa_run,
184: pay_action_interlocks pai,
185: pay_assignment_actions paa,
186: pay_payroll_actions ppa,
187: pay_action_information act_inf

Line 185: pay_assignment_actions paa,

181: cursor cur_supp_run is
182: select fnd_date.canonical_to_date(act_inf.action_information3)
183: from pay_assignment_actions paa_run,
184: pay_action_interlocks pai,
185: pay_assignment_actions paa,
186: pay_payroll_actions ppa,
187: pay_action_information act_inf
188: where ppa.payroll_action_id = paa.payroll_action_id
189: and ppa.report_type = 'IE_CESSATION'

Line 304: pay_assignment_actions paa,

300:
301: /* CURSOR get_last_source_id is
302: select source_id from
303: pay_action_information pai,
304: pay_assignment_actions paa,
305: pay_payroll_actions ppa,
306: pay_assignment_actions paa1
307: where paa.assignment_action_id = p_last_cess_action
308: and ppa.payroll_action_id=paa.payroll_action_id

Line 306: pay_assignment_actions paa1

302: select source_id from
303: pay_action_information pai,
304: pay_assignment_actions paa,
305: pay_payroll_actions ppa,
306: pay_assignment_actions paa1
307: where paa.assignment_action_id = p_last_cess_action
308: and ppa.payroll_action_id=paa.payroll_action_id
309: and ppa.payroll_action_id=paa1.payroll_action_id
310: and paa1.assignment_id=p_assignment_id

Line 320: pay_assignment_actions paa

316: /*8615992 */
317: CURSOR get_last_source_id is
318: select source_id from
319: pay_action_information pai,
320: pay_assignment_actions paa
321: where paa.assignment_action_id = p_last_cess_action
322: and paa.assignment_action_id = pai.action_context_id
323: and pai.action_information_category='IE CESS INFORMATION'
324: and pai.action_context_type = 'AAP'

Line 330: pay_assignment_actions paa,

326:
327: /* CURSOR get_last_source_id_apr_09 is
328: select source_id , ppa.effective_date from
329: pay_action_information pai,
330: pay_assignment_actions paa,
331: pay_payroll_actions ppa,
332: pay_assignment_actions paa1
333: where paa.assignment_action_id = p_last_cess_action
334: and ppa.payroll_action_id=paa.payroll_action_id

Line 332: pay_assignment_actions paa1

328: select source_id , ppa.effective_date from
329: pay_action_information pai,
330: pay_assignment_actions paa,
331: pay_payroll_actions ppa,
332: pay_assignment_actions paa1
333: where paa.assignment_action_id = p_last_cess_action
334: and ppa.payroll_action_id=paa.payroll_action_id
335: and ppa.payroll_action_id=paa1.payroll_action_id
336: and paa1.assignment_id=p_assignment_id

Line 344: pay_assignment_actions paa,

340: /*8615992 */
341: CURSOR get_last_source_id_apr_09 is
342: select source_id , ppa.effective_date from
343: pay_action_information pai,
344: pay_assignment_actions paa,
345: pay_payroll_actions ppa
346: where paa.assignment_action_id = p_last_cess_action
347: and ppa.payroll_action_id=paa.payroll_action_id
348: and paa.assignment_action_id = pai.action_context_id

Line 353: CURSOR get_asg_action_eff_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

349: and pai.action_information_category='IE CESS INFORMATION'
350: and pai.action_context_type = 'AAP';
351:
352:
353: CURSOR get_asg_action_eff_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
354: select ppa.effective_date
355: from pay_assignment_actions paa,
356: pay_payroll_actions ppa
357: where paa.assignment_action_id=c_assignment_action_id

Line 355: from pay_assignment_actions paa,

351:
352:
353: CURSOR get_asg_action_eff_date(c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
354: select ppa.effective_date
355: from pay_assignment_actions paa,
356: pay_payroll_actions ppa
357: where paa.assignment_action_id=c_assignment_action_id
358: and ppa.payroll_action_id=paa.payroll_action_id;
359:

Line 389: FROM pay_assignment_actions paa

385: /*8615992 */
386: CURSOR cur_assignment_action_apr_09(c_ppsn varchar2) is
387: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
388: paa.assignment_action_id),16))
389: FROM pay_assignment_actions paa
390: ,pay_payroll_actions ppa
391: -- ,pay_assignment_actions paa1
392: WHERE ((c_ppsn is null and paa.assignment_id=p_assignment_id) OR(c_ppsn is not null
393: and paa.assignment_id in (select paaf.assignment_id

Line 391: -- ,pay_assignment_actions paa1

387: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
388: paa.assignment_action_id),16))
389: FROM pay_assignment_actions paa
390: ,pay_payroll_actions ppa
391: -- ,pay_assignment_actions paa1
392: WHERE ((c_ppsn is null and paa.assignment_id=p_assignment_id) OR(c_ppsn is not null
393: and paa.assignment_id in (select paaf.assignment_id
394: from per_all_assignments_f paaf, per_assignment_extra_info paei
395: where paaf.person_id = p_person_id

Line 409: l_assignment_action_apr_09 pay_assignment_actions.assignment_action_id%type;

405: l_defined_balance_id pay_defined_balances.defined_balance_id%type;
406: l_balance_value NUMBER:=0;
407: l_balance_value1 NUMBER:=0;
408: /* 8615992 */
409: l_assignment_action_apr_09 pay_assignment_actions.assignment_action_id%type;
410: l_balance_value_apr_09 NUMBER:=0;
411: l_balance_value1_apr_09 NUMBER:=0;
412: l_cess_last_bal_value NUMBER :=0;
413: l_cess_last_bal_value_apr_09 NUMBER :=0;

Line 1598: pay_assignment_actions act,

1594: as1.assignment_number works_number,
1595: as1.period_of_service_id period_of_service_id
1596: FROM --per_periods_of_service ppos,
1597: per_all_assignments_f as1,
1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,
1601: pay_assignment_actions act1,
1602: pay_payroll_actions appa2

Line 1601: pay_assignment_actions act1,

1597: per_all_assignments_f as1,
1598: pay_assignment_actions act,
1599: pay_payroll_actions appa,
1600: pay_action_interlocks pai,
1601: pay_assignment_actions act1,
1602: pay_payroll_actions appa2
1603: WHERE /*appa.consolidation_set_id = p_consolidation_id*/
1604: act.tax_unit_id = p_paye_ref
1605: AND appa.effective_date BETWEEN g_archive_start_date AND g_archive_end_date

Line 1657: pay_assignment_actions act2,

1653: AND appa2.action_type IN ('P','U') -- Prepayments or Quickpay Prepayments
1654: AND appa2.payroll_action_id = (SELECT /*+ USE_NL(ACT2 APPA4)*/
1655: max(appa4.payroll_action_id)
1656: FROM /*pay_pre_payments ppp, --Bug 4193738 --Bug 4468864*/
1657: pay_assignment_actions act2,
1658: pay_payroll_actions appa4
1659: WHERE /*ppp.assignment_action_id=act2.assignment_action_id
1660: AND*/ act2.assignment_id = act.assignment_id
1661: AND act2.action_status = 'C'

Line 1668: from pay_assignment_actions act3,

1664: AND appa4.effective_date BETWEEN g_archive_start_date AND g_archive_end_date)
1665: -- bug 5597735, change the not exists clause.
1666: -- refer bug 5233518 for more details.
1667: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
1668: from pay_assignment_actions act3,
1669: pay_payroll_actions appa3,
1670: pay_action_interlocks pai, --bug 4208273
1671: pay_assignment_actions act2, --bug 4208273
1672: pay_payroll_actions appa4 --bug 4208273

Line 1671: pay_assignment_actions act2, --bug 4208273

1667: AND NOT EXISTS (SELECT /*+ ORDERED use_nl(appa3)*/ null
1668: from pay_assignment_actions act3,
1669: pay_payroll_actions appa3,
1670: pay_action_interlocks pai, --bug 4208273
1671: pay_assignment_actions act2, --bug 4208273
1672: pay_payroll_actions appa4 --bug 4208273
1673: where pai.locked_action_id= act3.assignment_action_id
1674: and pai.locking_action_id=act2.assignment_action_id
1675: and act3.action_sequence >= act1.action_sequence --bug 4193738

Line 1878: SELECT pay_assignment_actions_s.NEXTVAL

1874: THEN
1875:
1876: hr_utility.set_location('Different Person '|| csr_rec.person_id ,22);
1877:
1878: SELECT pay_assignment_actions_s.NEXTVAL
1879: INTO l_actid
1880: FROM dual;
1881:
1882: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 2028: pay_assignment_actions assact,

2024: FROM pay_action_interlocks pre,
2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,
2029: pay_assignment_actions passact,
2030: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
2031: WHERE pre.locked_action_id = pay.locking_action_id
2032: AND pre.locking_action_id = p_locking_action_id

Line 2029: pay_assignment_actions passact,

2025: pay_action_interlocks pay,
2026: pay_payroll_actions paa,
2027: pay_payroll_actions ppaa,
2028: pay_assignment_actions assact,
2029: pay_assignment_actions passact,
2030: per_time_periods ptp -- Added to retrieve correct time_period_id 4906850
2031: WHERE pre.locked_action_id = pay.locking_action_id
2032: AND pre.locking_action_id = p_locking_action_id
2033: AND pre.locked_action_id = passact.assignment_action_id

Line 2054: FROM pay_assignment_actions paa,

2050: p_lat_act_seq IN NUMBER) is
2051: SELECT /*+ USE_NL(paa, ppa) */
2052: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2053: paa.assignment_action_id),16))
2054: FROM pay_assignment_actions paa,
2055: pay_payroll_actions ppa
2056: WHERE paa.payroll_action_id = ppa.payroll_action_id
2057: AND paa.assignment_id in (select assignment_id
2058: from per_all_assignments_f

Line 2075: pay_assignment_actions cess_src,

2071: c_ppsn varchar2
2072: ) IS
2073: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
2074: FROM pay_payroll_actions ppa_cess,
2075: pay_assignment_actions cess_src,
2076: pay_action_information pai_cess,
2077: pay_assignment_actions paa_src
2078: WHERE ppa_cess.action_type = 'X'
2079: AND ppa_cess.report_type = 'IE_CESSATION'

Line 2077: pay_assignment_actions paa_src

2073: SELECT max(lpad(paa_src.action_sequence,15,'0')|| paa_src.assignment_action_id)
2074: FROM pay_payroll_actions ppa_cess,
2075: pay_assignment_actions cess_src,
2076: pay_action_information pai_cess,
2077: pay_assignment_actions paa_src
2078: WHERE ppa_cess.action_type = 'X'
2079: AND ppa_cess.report_type = 'IE_CESSATION'
2080: AND ppa_cess.report_qualifier = 'IE'
2081: AND ppa_cess.payroll_action_id <> p_pact_id

Line 2100: pay_assignment_actions paa,

2096: CURSOR cur_get_last_cess(p_person_id NUMBER,p_termination_date DATE,p_pact NUMBER, c_assignment_id NUMBER,c_ppsn varchar2) IS
2097: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2098: paa.assignment_action_id),16))
2099: FROM pay_payroll_actions ppa,
2100: pay_assignment_actions paa,
2101: pay_action_information pai
2102: WHERE paa.assignment_action_id = pai.action_context_id
2103: AND pai.action_information_category = 'IE CESS INFORMATION'
2104: AND pai.action_context_type = 'AAP'

Line 2119: CURSOR cur_get_cess_pact(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS

2115: AND ((c_ppsn is not null and pai.action_information22=c_ppsn) or (c_ppsn is null)) /* 8615992 */
2116: ;
2117:
2118:
2119: CURSOR cur_get_cess_pact(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
2120: SELECT paa.payroll_action_id
2121: FROM pay_assignment_actions paa
2122: WHERE paa.assignment_action_id = p_cess_aact;
2123:

Line 2121: FROM pay_assignment_actions paa

2117:
2118:
2119: CURSOR cur_get_cess_pact(p_cess_aact pay_assignment_actions.assignment_action_id%TYPE) IS
2120: SELECT paa.payroll_action_id
2121: FROM pay_assignment_actions paa
2122: WHERE paa.assignment_action_id = p_cess_aact;
2123:
2124: -- cursor to retrieve payroll id
2125: CURSOR cur_assgn_payroll(p_assignment_id NUMBER,

Line 2151: FROM pay_assignment_actions paa,

2147: c_ppsn_override per_assignment_extra_info.aei_information1%type) is
2148: SELECT /*+ USE_NL(paa, ppa) */
2149: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2150: paa.assignment_action_id),16))
2151: FROM pay_assignment_actions paa,
2152: pay_payroll_actions ppa
2153: WHERE paa.payroll_action_id = ppa.payroll_action_id
2154: AND paa.assignment_id in (select paaf.assignment_id
2155: from per_all_assignments_f paaf, per_assignment_extra_info paei

Line 2211: FROM pay_assignment_actions paa

2207:
2208: -- retrieve the chunk number for the current assignment action
2209: SELECT paa.chunk_number,paa.assignment_id
2210: INTO l_chunk_number,l_assignment_id
2211: FROM pay_assignment_actions paa
2212: WHERE paa.assignment_action_id = p_assactid;
2213:
2214: l_action_context_id := p_assactid;
2215: l_record_count := 0;

Line 2311: SELECT pay_assignment_actions_s.NEXTVAL

2307: THEN
2308: hr_utility.set_location(' entered if of else ',30);
2309: -- Create child cess action to lock the child payroll process child action
2310: -- To avoid data corruption 4468864
2311: SELECT pay_assignment_actions_s.NEXTVAL
2312: INTO l_actid
2313: FROM dual;
2314:
2315: hr_nonrun_asact.insact(

Line 2431: CURSOR cur_assignment_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is

2427: l_payroll_action_id NUMBER;
2428: l_asg_action_id NUMBER;
2429:
2430: l_assignment_id per_all_assignments_f.assignment_id%type;
2431: CURSOR cur_assignment_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
2432: select assignment_id
2433: from pay_assignment_actions
2434: where assignment_action_id=c_assignment_action_id;
2435:

Line 2433: from pay_assignment_actions

2429:
2430: l_assignment_id per_all_assignments_f.assignment_id%type;
2431: CURSOR cur_assignment_id (c_assignment_action_id pay_assignment_actions.assignment_action_id%type) is
2432: select assignment_id
2433: from pay_assignment_actions
2434: where assignment_action_id=c_assignment_action_id;
2435:
2436: l_assignment_id per_all_assignments_f.assignment_id%type;
2437:

Line 2439: CURSOR cur_cess_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS

2435:
2436: l_assignment_id per_all_assignments_f.assignment_id%type;
2437:
2438:
2439: CURSOR cur_cess_emp_details (c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
2440: select PAI_IEcess.ACTION_INFORMATION20 last_name,
2441: PAI_IEcess.ACTION_INFORMATION21 first_name,
2442: PAI_IEcess.ACTION_INFORMATION22 pps_no,
2443: PAI_IEcess.ACTION_INFORMATION23 works_no,