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

Line 1383: FROM pay_assignment_actions paa

1379: CURSOR csr_chk_corr_ele_exists(c_pay_act_id NUMBER) IS
1380: SELECT 'Y'
1381: FROM DUAL
1382: WHERE EXISTS (SELECT /*+ ORDERED */ 1
1383: FROM pay_assignment_actions paa
1384: ,pay_action_information pai
1385: WHERE paa.payroll_action_id = c_pay_act_id
1386: AND pai.action_context_id = paa.assignment_action_id
1387: AND pai.action_context_type = 'AAP'

Line 2262: pay_assignment_actions paa

2258: AND EXISTS
2259: (
2260: SELECT 1
2261: from
2262: pay_assignment_actions paa
2263: where
2264: paa.payroll_action_id = p_payroll_action_id
2265: and paa.action_status = 'C'
2266: and paa.assignment_id = paei.assignment_id

Line 3457: FROM pay_assignment_actions bal_assact

3453: CURSOR csr_chk_corr_ele_exists(c_ass_act_id NUMBER) IS
3454: SELECT 'Y'
3455: FROM DUAL
3456: WHERE EXISTS (SELECT /*+ ORDERED */ 1
3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf

Line 3459: ,pay_assignment_actions assact

3455: FROM DUAL
3456: WHERE EXISTS (SELECT /*+ ORDERED */ 1
3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
3460: -- ,pay_payroll_actions pact
3461: ,pay_element_types_f adj_petf
3462: ,pay_run_results adj_prr
3463: WHERE bal_assact.assignment_action_id = c_ass_act_id -- assignment_action_id

Line 4195: FROM PAY_ASSIGNMENT_ACTIONS paa

4191: fnd_number.number_to_canonical(ROUND(SUM(NVL(fnd_number.canonical_to_number(pai.ACTION_INFORMATION22),0)))) VergZvw
4192: FROM PAY_ACTION_INFORMATION pai
4193: WHERE ACTION_CONTEXT_ID IN
4194: (SELECT ASSIGNMENT_ACTION_ID
4195: FROM PAY_ASSIGNMENT_ACTIONS paa
4196: WHERE PAYROLL_ACTION_ID=c_payroll_action_id)
4197: AND ACTION_INFORMATION_CATEGORY='NL_WR_NOMINATIVE_REPORT'
4198: AND ACTION_INFORMATION1='INITIAL';
4199:

Line 4209: FROM PAY_ASSIGNMENT_ACTIONS paa

4205: fnd_number.number_to_canonical(ROUND(SUM(NVL(fnd_number.canonical_to_number(ACTION_INFORMATION9),0)))) PrLnWgf
4206: FROM pay_action_information pai
4207: WHERE ACTION_CONTEXT_ID IN
4208: (SELECT ASSIGNMENT_ACTION_ID
4209: FROM PAY_ASSIGNMENT_ACTIONS paa
4210: WHERE PAYROLL_ACTION_ID=c_payroll_action_id)
4211: AND ACTION_INFORMATION_CATEGORY ='NL_WR_SWMF_SECTOR_RISK_GROUP';
4212: --AND ACTION_INFORMATION1='SWMF'
4213: */

Line 4248: FROM PAY_ASSIGNMENT_ACTIONS paa

4244: count(*) over(partition by ACTION_INFORMATION18,ACTION_INFORMATION5) NumIVPersNr
4245: FROM pay_action_information pai
4246: WHERE ACTION_CONTEXT_ID IN
4247: (SELECT ASSIGNMENT_ACTION_ID
4248: FROM PAY_ASSIGNMENT_ACTIONS paa
4249: WHERE PAYROLL_ACTION_ID=c_payroll_action_id)
4250: AND ACTION_INFORMATION_CATEGORY = 'NL_WR_EMPLOYMENT_INFO'
4251: AND ACTION_INFORMATION1=c_payroll_type)
4252: WHERE (NumIVPersNr+NumIVSofi)>2;

Line 4265: ,pay_assignment_actions paa

4261: fnd_date.canonical_to_date(pai1.action_information2) start_date
4262: ,fnd_date.canonical_to_date(pai1.action_information3) end_date
4263: FROM pay_action_information pai1,
4264: pay_action_information pai2
4265: ,pay_assignment_actions paa
4266: WHERE pai1.action_context_type = 'AAP'
4267: AND pai2.action_context_type = 'AAP'
4268: AND pai1.action_information_category = 'NL_WR_EMPLOYMENT_INFO'
4269: AND pai2.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 4309: FROM pay_assignment_actions paa

4305: -- cursor to get distinct start date and end date for the records archived
4306: CURSOR csr_period_dates(c_pact_id NUMBER) IS
4307: SELECT DISTINCT pai.Action_Information2 Start_date
4308: ,pai.action_information3 End_date
4309: FROM pay_assignment_actions paa
4310: ,pay_action_information pai
4311: WHERE paa.payroll_action_id = c_pact_id
4312: AND paa.assignment_action_id = pai.action_context_id
4313: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 4353: FROM pay_assignment_actions paa

4349: -- Correction balance total periods
4350: CURSOR csr_ret_cor_period(c_pact_id NUMBER) IS
4351: SELECT DISTINCT fnd_date.canonical_to_date(pai.Action_Information2) Start_date
4352: ,fnd_date.canonical_to_date(pai.action_information3) End_date
4353: FROM pay_assignment_actions paa
4354: ,pay_action_information pai
4355: WHERE paa.payroll_action_id = c_pact_id
4356: AND paa.assignment_action_id = pai.action_context_id
4357: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 4423: FROM pay_assignment_actions paa

4419: ,pai_p.action_information6 Description
4420: ,substr(pai_p.action_information7,1,30) E_Name
4421: ,substr(pai_p.action_information8,1,30) E_Number
4422: ,pai_p.action_context_type cxt
4423: FROM pay_assignment_actions paa
4424: ,pay_action_information pai_p
4425: WHERE paa.payroll_action_id = p_payroll_action_id
4426: AND pai_p.action_context_id = paa.assignment_action_id
4427: AND pai_p.action_information_category = 'NL_WR_EXCEPTION_REPORT'

Line 4442: FROM pay_assignment_actions paa

4438: --#
4439: --
4440: CURSOR csr_get_pactid IS
4441: SELECT DISTINCT paa1.payroll_action_id
4442: FROM pay_assignment_actions paa
4443: ,pay_action_interlocks pal
4444: ,pay_assignment_actions paa1
4445: WHERE paa.payroll_action_id = p_actid
4446: AND paa.assignment_action_id = pal.locking_action_id

Line 4444: ,pay_assignment_actions paa1

4440: CURSOR csr_get_pactid IS
4441: SELECT DISTINCT paa1.payroll_action_id
4442: FROM pay_assignment_actions paa
4443: ,pay_action_interlocks pal
4444: ,pay_assignment_actions paa1
4445: WHERE paa.payroll_action_id = p_actid
4446: AND paa.assignment_action_id = pal.locking_action_id
4447: AND pal.locked_action_id = paa1.assignment_action_id
4448: ORDER BY paa1.payroll_action_id DESC;

Line 4479: FROM pay_assignment_actions paa1

4475: AND pai.action_context_type = 'PA'
4476: AND pai.action_context_id = ppa.payroll_action_id
4477: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
4478: AND EXISTS ( SELECT 1
4479: FROM pay_assignment_actions paa1
4480: ,pay_action_interlocks ai
4481: ,pay_assignment_actions paa2
4482: WHERE paa1.payroll_action_id = p_actid
4483: AND paa1.assignment_action_id = ai.locking_action_id

Line 4481: ,pay_assignment_actions paa2

4477: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
4478: AND EXISTS ( SELECT 1
4479: FROM pay_assignment_actions paa1
4480: ,pay_action_interlocks ai
4481: ,pay_assignment_actions paa2
4482: WHERE paa1.payroll_action_id = p_actid
4483: AND paa1.assignment_action_id = ai.locking_action_id
4484: AND ai.locked_action_id = paa2.assignment_action_id
4485: AND paa2.payroll_action_id = ppa.payroll_action_id)

Line 4490: FROM pay_assignment_actions paa

4486: GROUP BY action_information7,action_information8;
4487: --
4488: CURSOR csr_payroll_get_action_id(c_payroll_action_id NUMBER) IS
4489: SELECT max(locked_action_id)
4490: FROM pay_assignment_actions paa
4491: ,pay_payroll_actions ppa
4492: ,pay_action_interlocks pai
4493: WHERE ppa.payroll_action_id = c_payroll_action_id
4494: AND paa.payroll_action_id = ppa.payroll_action_id

Line 4501: FROM pay_assignment_actions paa

4497: CURSOR csr_payroll_get_action_id2(c_payroll_action_id NUMBER
4498: ,c_start_date DATE
4499: ,c_end_date DATE) IS
4500: SELECT max(paa2.assignment_action_id)
4501: FROM pay_assignment_actions paa
4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2

Line 4504: ,pay_assignment_actions paa1

4500: SELECT max(paa2.assignment_action_id)
4501: FROM pay_assignment_actions paa
4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2
4506: ,pay_payroll_actions ppa2
4507: WHERE ppa.payroll_action_id = c_payroll_action_id
4508: AND paa.payroll_action_id = ppa.payroll_action_id

Line 4505: ,pay_assignment_actions paa2

4501: FROM pay_assignment_actions paa
4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2
4506: ,pay_payroll_actions ppa2
4507: WHERE ppa.payroll_action_id = c_payroll_action_id
4508: AND paa.payroll_action_id = ppa.payroll_action_id
4509: AND pai.locking_action_id = paa.assignment_action_id

Line 4520: FROM pay_assignment_actions paa1

4516: AND ppa2.action_status = 'C';
4517: --
4518: CURSOR csr_get_prev_period(c_ass_act_id NUMBER) IS
4519: SELECT paa2.assignment_action_id, ptp2.end_date
4520: FROM pay_assignment_actions paa1
4521: ,pay_payroll_actions ppa1
4522: ,pay_assignment_actions paa2
4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1

Line 4522: ,pay_assignment_actions paa2

4518: CURSOR csr_get_prev_period(c_ass_act_id NUMBER) IS
4519: SELECT paa2.assignment_action_id, ptp2.end_date
4520: FROM pay_assignment_actions paa1
4521: ,pay_payroll_actions ppa1
4522: ,pay_assignment_actions paa2
4523: ,pay_payroll_actions ppa2
4524: ,per_time_periods ptp1
4525: ,per_time_periods ptp2
4526: ,pay_all_payrolls_f ppf1

Line 4563: FROM pay_assignment_actions paa

4559: -- Correction balance total periods
4560: CURSOR csr_ret_cor_period1(c_pact_id NUMBER) IS
4561: SELECT DISTINCT pai.Action_Information2 Start_date
4562: ,pai.action_information3 End_date
4563: FROM pay_assignment_actions paa
4564: ,pay_action_information pai
4565: WHERE paa.payroll_action_id = c_pact_id
4566: AND paa.assignment_action_id = pai.action_context_id
4567: AND pai.action_information_category = 'NL_WR_EMPLOYMENT_INFO'

Line 4671: pay_assignment_actions paa,

4667: IS
4668: select max(paa.assignment_action_id)
4669: from
4670: pay_payroll_actions ppa,
4671: pay_assignment_actions paa,
4672: pay_payrolls_f ppf
4673: where
4674: ppa.payroll_action_id = paa.payroll_action_id
4675: AND ppa.business_group_id = p_bg_id

Line 4704: pay_assignment_actions paa

4700: AND EXISTS
4701: (
4702: SELECT 1
4703: from
4704: pay_assignment_actions paa
4705: where
4706: paa.payroll_action_id = p_payroll_action_id
4707: and paa.action_status = 'C'
4708: and paa.assignment_id = paei.assignment_id

Line 7188: ,pay_assignment_actions paa

7184: ,paa.assignment_action_id assignment_action_id
7185: FROM per_all_assignments_f asl
7186: ,pay_all_payrolls_f ppf
7187: ,pay_payroll_actions ppa
7188: ,pay_assignment_actions paa
7189: ,per_time_periods ptp
7190: WHERE asl.person_id BETWEEN stperson AND endperson and
7191: ppf.payroll_id = asl.payroll_id
7192: AND ((ppf.period_type = 'Calendar Month'

Line 7213: FROM pay_assignment_actions paa1

7209: AND ppf.effective_end_date
7210: AND asl.business_group_id = ppa.business_group_id
7211: AND ppa.business_group_id = c_business_group_id
7212: AND (EXISTS (SELECT 1
7213: FROM pay_assignment_actions paa1
7214: ,pay_run_results prr
7215: WHERE paa1.source_action_id = paa.assignment_action_id
7216: AND prr.assignment_action_id = paa1.assignment_action_id))
7217: UNION

Line 7286: ,pay_assignment_actions paa

7282: ,ppa1.effective_date
7283: ,paaf.primary_flag
7284: FROM pay_payroll_actions ppa
7285: ,pay_payroll_actions ppa1
7286: ,pay_assignment_actions paa
7287: ,per_all_assignments_f paaf
7288: WHERE ppa.report_type = 'NL_WAGES_REP_LOCK'
7289: AND ppa.report_qualifier = 'NL'
7290: AND ppa.action_type = 'X'

Line 7330: ,pay_assignment_actions paa

7326: SELECT DISTINCT asl.assignment_id assignment_id
7327: ,paa.assignment_action_id assignment_action_id
7328: FROM per_all_assignments_f asl
7329: ,pay_payroll_actions ppa
7330: ,pay_assignment_actions paa
7331: ,per_time_periods ptp
7332: WHERE asl.person_id BETWEEN stperson AND endperson and
7333: ppa.payroll_id = asl.payroll_id
7334: AND ppa.action_type in ('R','Q')

Line 7347: FROM pay_assignment_actions paa1

7343: AND asl.effective_end_date >= c_start_date
7344: AND asl.business_group_id = ppa.business_group_id
7345: AND ppa.business_group_id = c_business_group_id
7346: AND (EXISTS (SELECT 1
7347: FROM pay_assignment_actions paa1
7348: ,pay_run_results prr
7349: WHERE paa1.source_action_id = paa.assignment_action_id
7350: AND prr.assignment_action_id = paa1.assignment_action_id))
7351: UNION

Line 7388: ,pay_assignment_actions paa

7384: ,paa.assignment_action_id assignment_action_id
7385: FROM per_all_assignments_f asl
7386: ,pay_all_payrolls_f ppf
7387: ,pay_payroll_actions ppa
7388: ,pay_assignment_actions paa
7389: ,per_time_periods ptp
7390: WHERE asl.person_id between stperson AND endperson and
7391: ppf.payroll_id = asl.payroll_id
7392: AND ((ppf.period_type = 'Calendar Month'

Line 7415: FROM pay_assignment_actions paa1

7411: AND ppf.effective_end_date
7412: AND asl.business_group_id = ppa.business_group_id
7413: AND ppa.business_group_id = c_business_group_id
7414: AND (EXISTS (SELECT 1
7415: FROM pay_assignment_actions paa1
7416: ,pay_run_results prr
7417: WHERE paa1.source_action_id = paa.assignment_action_id
7418: AND prr.assignment_action_id = paa1.assignment_action_id))
7419: AND EXISTS

Line 7436: ,pay_assignment_actions paa1

7432: ,pay_element_span_usages esu
7433: ,pay_retro_component_usages rcu
7434: ,pay_retro_components rc
7435: ,pay_element_entries_f pee1
7436: ,pay_assignment_actions paa1
7437: ,pay_payroll_actions ppa1
7438: ,per_time_periods ptp
7439: WHERE paa1.source_action_id = paa.assignment_action_id
7440: --AND paa1.assignment_action_id = paa.assignment_action_id

Line 7522: SELECT pay_assignment_actions_s.NEXTVAL

7518: IF csr_persons_rec.person_id <> l_chk_person_id THEN
7519: --
7520: l_chk_person_id := csr_persons_rec.person_id;
7521: --
7522: SELECT pay_assignment_actions_s.NEXTVAL
7523: INTO l_actid
7524: FROM dual;
7525: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
7526: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7541: SELECT pay_assignment_actions_s.NEXTVAL

7537: l_chk_assignment_id := 0;
7538: FOR csr_rec IN csr_assignments_yearly(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
7539: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7540: l_chk_assignment_id := csr_rec.assignment_id;
7541: SELECT pay_assignment_actions_s.NEXTVAL
7542: INTO l_actid
7543: FROM dual;
7544: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
7545: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION

Line 7568: SELECT pay_assignment_actions_s.NEXTVAL

7564: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7565: l_chk_assignment_id := csr_rec.assignment_id;
7566:
7567: IF csr_rec.assignment_action_id IS NOT NULL THEN --10100628
7568: SELECT pay_assignment_actions_s.NEXTVAL
7569: INTO l_actid
7570: FROM dual;
7571: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7572: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7592: SELECT pay_assignment_actions_s.NEXTVAL

7588: --
7589: FOR csr_rec IN csr_assignments(stperson,endperson,l_start_date,l_end_date,l_business_group_id,l_payroll_type,l_legal_employer,l_paid_flag) LOOP
7590: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7591: l_chk_assignment_id := csr_rec.assignment_id;
7592: SELECT pay_assignment_actions_s.NEXTVAL
7593: INTO l_actid
7594: FROM dual;
7595: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7596: hr_nonrun_asact.insact(lockingactid => l_actid

Line 7621: FROM pay_assignment_actions paa

7617: --
7618: CURSOR csr_assignment_actions(p_arc_pactid NUMBER) IS
7619: SELECT paa.assignment_action_id
7620: ,paa.assignment_id
7621: FROM pay_assignment_actions paa
7622: ,per_all_assignments_f paaf
7623: ,pay_payroll_actions ppa
7624: WHERE paa.payroll_action_id = p_arc_pactid
7625: AND paa.payroll_action_id = ppa.payroll_action_id

Line 7644: SELECT pay_assignment_actions_s.NEXTVAL

7640: l_arc_pactid := TO_NUMBER(get_parameters(p_actid,'REQUEST_ID'));
7641: --
7642: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
7643: --
7644: SELECT pay_assignment_actions_s.NEXTVAL
7645: INTO l_actid
7646: FROM dual;
7647: --
7648: hr_nonrun_asact.insact(lockingactid => l_actid

Line 9662: FROM pay_assignment_actions paa

9658: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS
9659: SELECT 'Y'
9660: FROM DUAL
9661: WHERE EXISTS(SELECT /*+ ORDERED */ 1
9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
9665: ,pay_assignment_actions pal
9666: ,pay_payroll_actions ppl

Line 9665: ,pay_assignment_actions pal

9661: WHERE EXISTS(SELECT /*+ ORDERED */ 1
9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
9665: ,pay_assignment_actions pal
9666: ,pay_payroll_actions ppl
9667: WHERE paa.assignment_id = c_assignment_id
9668: AND paa.payroll_action_id = ppa.payroll_action_id
9669: AND ppa.report_type = 'NL_WAGES_REP_ARCHIVE'

Line 9711: ,pay_assignment_actions paa

9707: SELECT DISTINCT ptp.start_date start_date
9708: ,ptp.end_date end_date
9709: FROM pay_run_results prr
9710: ,pay_element_entries_f pee
9711: ,pay_assignment_actions paa
9712: ,pay_payroll_actions ppa
9713: ,per_time_periods ptp
9714: WHERE prr.assignment_action_id = paa.assignment_action_id
9715: AND prr.element_type_id = pee.element_type_id

Line 9768: ,pay_assignment_actions paa

9764: ,pay_element_span_usages esu
9765: ,pay_retro_component_usages rcu
9766: ,pay_retro_components rc
9767: ,pay_element_entries_f pee1
9768: ,pay_assignment_actions paa
9769: ,pay_payroll_actions ppa
9770: ,per_time_periods ptp
9771: WHERE paa.assignment_action_id = c_assignment_action_id
9772: AND rr1.assignment_action_id = paa.assignment_action_id

Line 9803: FROM pay_assignment_actions paa

9799: --
9800: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
9801: ,c_date DATE) IS
9802: SELECT max(paa.assignment_action_id) assignment_action_id
9803: FROM pay_assignment_actions paa
9804: ,pay_payroll_actions ppa
9805: ,per_time_periods ptp
9806: WHERE paa.assignment_id = c_assignment_id
9807: AND ppa.payroll_action_id = paa.payroll_action_id

Line 9819: FROM pay_assignment_actions paa

9815: CURSOR csr_get_assignment_action_id2(c_assignment_id NUMBER
9816: ,c_date DATE) IS
9817: SELECT --max(paa.assignment_action_id) assignment_action_id --11731857
9818: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) assignment_action_id --11731857
9819: FROM pay_assignment_actions paa
9820: ,pay_payroll_actions ppa
9821: ,per_time_periods ptp
9822: WHERE paa.assignment_id = c_assignment_id
9823: AND ppa.payroll_action_id = paa.payroll_action_id

Line 9990: ,pay_assignment_actions paa

9986: FROM per_all_assignments_f asl
9987: ,per_all_assignments_f asl2
9988: ,pay_all_payrolls_f ppf
9989: ,pay_payroll_actions ppa
9990: ,pay_assignment_actions paa
9991: ,per_time_periods ptp
9992: WHERE asl.person_id = asl2.person_id
9993: AND asl2.assignment_id = c_assg_id
9994: AND ppf.payroll_id = asl.payroll_id

Line 10131: pay_assignment_actions paa,

10127: IS
10128: select distinct ptp.start_date, ptp.end_date
10129: from
10130: pay_payroll_actions ppa,
10131: pay_assignment_actions paa,
10132: per_time_periods ptp
10133: where
10134: ppa.action_type in ('R', 'Q')
10135: and ppa.payroll_action_id = paa.payroll_action_id

Line 14015: FROM pay_assignment_actions paa

14011: --
14012: CURSOR csr_get_assignment_action_id(c_assignment_id NUMBER
14013: ,c_date DATE) IS
14014: SELECT max(paa.assignment_action_id) assignment_action_id
14015: FROM pay_assignment_actions paa
14016: ,pay_payroll_actions ppa
14017: ,per_time_periods ptp
14018: WHERE paa.assignment_id = c_assignment_id
14019: AND ppa.payroll_action_id = paa.payroll_action_id

Line 14032: FROM pay_assignment_actions paa

14028: ,c_date DATE
14029: ,c_end_date DATE) IS
14030: SELECT --max(paa.assignment_action_id) assignment_action_id
14031: fnd_number.canonical_to_number(substr(max(lpad(NVL(paa.action_sequence,0),15,'0')||paa.assignment_action_id),16)) assignment_action_id --11731857
14032: FROM pay_assignment_actions paa
14033: ,pay_payroll_actions ppa
14034: ,per_time_periods ptp
14035: WHERE paa.assignment_id = c_assignment_id
14036: AND ppa.payroll_action_id = paa.payroll_action_id

Line 14187: ,pay_assignment_actions paa

14183: SELECT distinct asl.assignment_id assignment_id
14184: FROM per_all_assignments_f asl
14185: ,per_all_assignments_f asl2
14186: ,pay_payroll_actions ppa
14187: ,pay_assignment_actions paa
14188: ,per_time_periods ptp
14189: WHERE asl.person_id = asl2.person_id
14190: AND asl2.assignment_id = c_assg_id
14191: AND ppa.payroll_id = asl.payroll_id

Line 14684: pay_assignment_actions paa,

14680: IS
14681: select max(paa.assignment_action_id) assignment_action_id, ptp.start_date, ptp.end_date
14682: from
14683: pay_payroll_actions ppa,
14684: pay_assignment_actions paa,
14685: per_time_periods ptp
14686: where
14687: ppa.action_type in ('R', 'Q')
14688: and ppa.payroll_action_id = paa.payroll_action_id

Line 14715: ,pay_assignment_actions paa1

14711: ,pay_element_span_usages esu
14712: ,pay_retro_component_usages rcu
14713: ,pay_retro_components rc
14714: ,pay_element_entries_f pee1
14715: ,pay_assignment_actions paa1
14716: ,pay_payroll_actions ppa1
14717: ,per_time_periods ptp
14718: WHERE --paa1.source_action_id = paa.assignment_action_id
14719: paa1.assignment_action_id = paa.assignment_action_id

Line 14750: ,pay_assignment_actions paa

14746: ,pay_element_span_usages esu
14747: ,pay_retro_component_usages rcu
14748: ,pay_retro_components rc
14749: ,pay_element_entries_f pee1
14750: ,pay_assignment_actions paa
14751: ,pay_payroll_actions ppa
14752: ,per_time_periods ptp
14753: WHERE paa.assignment_action_id = c_assignment_action_id
14754: AND rr1.assignment_action_id = paa.assignment_action_id

Line 14779: from pay_assignment_actions

14775: --
14776: --Fnd_file.put_line(FND_FILE.LOG,' Entering Archive Code for Assignment :'||p_assactid);
14777: select payroll_action_id,assignment_id
14778: into l_pactid, l_assignment_id
14779: from pay_assignment_actions
14780: where assignment_action_id = p_assactid;
14781: --
14782: get_all_parameters (l_pactid
14783: ,l_business_group_id

Line 14836: FROM pay_assignment_actions paa

14832: FROM pay_action_information pai
14833: WHERE action_context_id = c_payroll_action_id
14834: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')
14835: OR EXISTS (SELECT 1
14836: FROM pay_assignment_actions paa
14837: ,pay_action_information pai
14838: WHERE paa.payroll_action_id = c_payroll_action_id
14839: AND pai.action_context_id = paa.assignment_action_id
14840: AND pai.action_information_category = 'NL_WR_EXCEPTION_REPORT');