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

Line 360: FROM pay_assignment_actions paa_init,

356: p_end_date DATE,
357: p_consolidation_set_id NUMBER) IS
358: SELECT paa_init.assignment_id,
359: paa_init.assignment_action_id
360: FROM pay_assignment_actions paa_init,
361: pay_payroll_actions ppa_init,
362: per_all_assignments_f paf
363: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
364: AND ppa_init.action_type='I'

Line 379: FROM pay_assignment_actions paa_arch

375: ,'I'
376: ,ppa_init.effective_date
377: )
378: AND NOT EXISTS (SELECT NULL
379: FROM pay_assignment_actions paa_arch
380: ,pay_payroll_actions ppa_arch
381: ,pay_action_interlocks intk
382: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
383: AND intk.locked_action_id = paa_init.assignment_action_id

Line 440: SELECT pay_assignment_actions_s.NEXTVAL

436: END IF;
437:
438: FOR i in csr_bal_init (l_payroll_id,l_canonical_start_date,l_canonical_end_date,l_consolidation_set)
439: LOOP
440: SELECT pay_assignment_actions_s.NEXTVAL
441: INTO l_actid
442: FROM dual;
443:
444: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE 'I' ASSIGNMENT ACTION

Line 524: ,pay_assignment_actions paa

520: FROM pay_accrual_plans pap
521: ,pay_element_types_f pet
522: ,pay_element_links_f pel
523: ,pay_element_entries_f pee
524: ,pay_assignment_actions paa
525: ,pay_payroll_actions ppa
526: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
527: AND pel.element_type_id = pet.element_type_id
528: AND pee.element_link_id = pel.element_link_id

Line 715: FROM pay_assignment_actions paa

711: ,pet.reporting_name reporting_name
712: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
713: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
714: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
715: FROM pay_assignment_actions paa
716: ,pay_payroll_actions ppa
717: ,pay_run_results prr
718: ,pay_run_result_values prrv
719: ,per_time_periods ptp

Line 1244: ,pay_assignment_actions paa

1240: )
1241: IS
1242: select count(paa.assignment_action_id)
1243: from pay_payroll_actions ppa
1244: ,pay_assignment_actions paa
1245: ,pay_action_interlocks pal
1246: where pal.locking_action_id=p_prepayment_lcking_id
1247: and paa.assignment_action_id=pal.locked_action_id
1248: and ppa.payroll_action_id=paa.payroll_action_id

Line 1260: ,pay_assignment_actions paa

1256: select paa.assignment_action_id assignment_action_id
1257: ,ppa.date_earned date_earned
1258: ,ppa.effective_date effective_date
1259: from pay_payroll_actions ppa
1260: ,pay_assignment_actions paa
1261: ,pay_action_interlocks pal
1262: where pal.locking_action_id=p_prepayment_lcking_id
1263: and paa.assignment_action_id=pal.locked_action_id
1264: and ppa.payroll_action_id=paa.payroll_action_id

Line 1595: ,pay_assignment_actions paa

1591: SELECT hoi.org_information1
1592: FROM hr_soft_coding_keyflex hsck
1593: ,hr_organization_information hoi
1594: ,per_assignments_f paaf
1595: ,pay_assignment_actions paa
1596: ,pay_payroll_actions ppa
1597: WHERE paa.assignment_action_id = p_assactid
1598: AND paa.payroll_action_id = ppa.payroll_action_id
1599: AND paa.assignment_id = paaf.assignment_id

Line 1612: FROM pay_assignment_actions

1608:
1609: CURSOR csr_tax_unit_id
1610: IS
1611: SELECT tax_unit_id
1612: FROM pay_assignment_actions
1613: WHERE assignment_action_id = p_curr_pymt_ass_act_id;
1614: --
1615:
1616:

Line 1988: ,pay_assignment_actions paa

1984: ,pep.sex -- added for ECR
1985: ,pep.date_of_birth -- added for ECR
1986: FROM per_assignments_f asg
1987: ,per_people_f pep
1988: ,pay_assignment_actions paa
1989: ,per_contact_relationships con
1990: WHERE asg.PERSON_ID=pep.person_id
1991: AND asg.assignment_id=paa.assignment_id
1992: AND paa.assignment_action_id= p_assignment_action_id

Line 2012: ,pay_assignment_actions paa

2008: select DISTINCT hoi.organization_id source_id
2009: from hr_organization_units hoi
2010: ,hr_soft_coding_keyflex scf
2011: ,per_assignments_f asg
2012: ,pay_assignment_actions paa
2013: where asg.assignment_id=paa.assignment_id
2014: and paa.assignment_action_id=p_assignment_action_id
2015: and asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID
2016: and hoi.ORGANIZATION_ID=scf.segment2

Line 2658: ,pay_assignment_actions paa

2654: SELECT DISTINCT hoi.organization_id source_id
2655: FROM hr_organization_units hoi
2656: ,hr_soft_coding_keyflex scf
2657: ,per_assignments_f asg
2658: ,pay_assignment_actions paa
2659: WHERE asg.assignment_id=paa.assignment_id
2660: AND paa.assignment_action_id=p_assignment_action_id
2661: AND asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID
2662: AND hoi.ORGANIZATION_ID=scf.segment4

Line 2688: ,pay_assignment_actions paa

2684: ,pep.per_information9 ESI_Number
2685: ,pep.person_id person_id
2686: FROM per_assignments_f asg
2687: ,per_people_f pep
2688: ,pay_assignment_actions paa
2689: WHERE asg.PERSON_ID=pep.person_id
2690: AND asg.assignment_id=paa.assignment_id
2691: AND paa.assignment_action_id= p_assignment_action_id
2692: AND p_payroll_date BETWEEN pep.effective_start_date AND pep.effective_end_date

Line 3629: ,pay_assignment_actions paa

3625: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3626: FROM hr_organization_units hoi
3627: ,hr_soft_coding_keyflex scf
3628: ,per_assignments_f asg
3629: ,pay_assignment_actions paa
3630: WHERE asg.assignment_id = paa.assignment_id
3631: AND paa.assignment_action_id = p_assignment_action_id
3632: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
3633: AND hoi.organization_id = scf.segment3

Line 3650: ,pay_assignment_actions paa

3646: ,asg.effective_end_date
3647: FROM hr_organization_units hoi
3648: ,hr_soft_coding_keyflex scf
3649: ,per_assignments_f asg
3650: ,pay_assignment_actions paa
3651: WHERE asg.assignment_id = paa.assignment_id
3652: AND paa.assignment_action_id = p_assignment_action_id
3653: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
3654: AND hoi.organization_id = scf.segment3

Line 3669: ,pay_assignment_actions paa

3665: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3666: ,pep.person_id person_id
3667: FROM per_assignments_f asg
3668: ,per_people_f pep
3669: ,pay_assignment_actions paa
3670: WHERE asg.person_id = pep.person_id
3671: AND asg.assignment_id = paa.assignment_id
3672: AND paa.assignment_action_id = p_assignment_action_id
3673: AND p_payroll_date BETWEEN pep.effective_start_date AND pep.effective_end_date

Line 4259: FROM pay_assignment_actions paa_arch

4255: ,paa_init.assignment_action_id init_assignment_action_id
4256: ,ppa_init.payroll_action_id init_payroll_action_id
4257: ,ppa_init.effective_date init_effective_date
4258: ,paa_arch.assignment_id
4259: FROM pay_assignment_actions paa_arch
4260: ,pay_action_interlocks intk
4261: ,pay_assignment_actions paa_init
4262: ,pay_payroll_actions ppa_init
4263: WHERE paa_arch.assignment_action_id = p_init_arch_action_id

Line 4261: ,pay_assignment_actions paa_init

4257: ,ppa_init.effective_date init_effective_date
4258: ,paa_arch.assignment_id
4259: FROM pay_assignment_actions paa_arch
4260: ,pay_action_interlocks intk
4261: ,pay_assignment_actions paa_init
4262: ,pay_payroll_actions ppa_init
4263: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4264: AND intk.locking_action_id = paa_arch.assignment_action_id
4265: AND intk.locked_action_id = paa_init.assignment_action_id

Line 4289: FROM pay_assignment_actions paa_arch_mst

4285: ,ptp.end_date period_end_date
4286: ,ptp.time_period_id
4287: ,ptp.start_date period_start_date
4288: ,ptp.regular_payment_date
4289: FROM pay_assignment_actions paa_arch_mst
4290: ,pay_assignment_actions paa_arch_chd
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre

Line 4290: ,pay_assignment_actions paa_arch_chd

4286: ,ptp.time_period_id
4287: ,ptp.start_date period_start_date
4288: ,ptp.regular_payment_date
4289: FROM pay_assignment_actions paa_arch_mst
4290: ,pay_assignment_actions paa_arch_chd
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg

Line 4292: ,pay_assignment_actions paa_pre

4288: ,ptp.regular_payment_date
4289: FROM pay_assignment_actions paa_arch_mst
4290: ,pay_assignment_actions paa_arch_chd
4291: ,pay_action_interlocks pai_pre
4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run

Line 4296: ,pay_assignment_actions paa_run

4292: ,pay_assignment_actions paa_pre
4293: ,pay_payroll_actions ppa_pre
4294: ,per_business_groups pbg
4295: ,pay_action_interlocks pai_run
4296: ,pay_assignment_actions paa_run
4297: ,pay_payroll_actions ppa_run
4298: ,per_time_periods ptp
4299: WHERE paa_arch_mst.assignment_action_id = p_master_aa_id
4300: AND paa_arch_chd.source_action_id = paa_arch_mst.assignment_action_id

Line 4325: FROM pay_assignment_actions paa_run2

4321: -- Get the highest in sequence for this payslip
4322: AND paa_run.action_sequence =
4323: (
4324: SELECT MAX(paa_run2.action_sequence)
4325: FROM pay_assignment_actions paa_run2
4326: ,pay_action_interlocks pai_run2
4327: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
4328: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
4329: );

Line 4338: ,pay_assignment_actions paa

4334: )
4335: IS
4336: select count(paa.assignment_action_id)
4337: from pay_payroll_actions ppa
4338: ,pay_assignment_actions paa
4339: ,pay_action_interlocks pal
4340: where pal.locking_action_id=p_prepayment_lcking_id
4341: and paa.assignment_action_id=pal.locked_action_id
4342: and ppa.payroll_action_id=paa.payroll_action_id

Line 4356: ,pay_assignment_actions paa

4352: IS
4353: select paa.assignment_action_id
4354: ,ppa.date_earned
4355: from pay_payroll_actions ppa
4356: ,pay_assignment_actions paa
4357: ,pay_action_interlocks pal
4358: where pal.locking_action_id=p_prepayment_lcking_id
4359: and paa.assignment_action_id=pal.locked_action_id
4360: and ppa.payroll_action_id=paa.payroll_action_id

Line 4373: FROM pay_payroll_actions ppa,pay_assignment_actions paa,

4369: ,c_assignment_id NUMBER
4370: ,c_payroll_date date)
4371: IS
4372: SELECT paa.assignment_action_id
4373: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4374: pay_action_interlocks pai1,pay_action_interlocks pai2
4375:
4376: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4377: AND paa.ASSIGNMENT_ID = c_assignment_id

Line 4395: pay_assignment_actions paa,

4391: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
4392: IS
4393: SELECT pps.actual_termination_date
4394: FROM pay_payroll_actions ppa,
4395: pay_assignment_actions paa,
4396: per_time_periods ptp,
4397: per_all_assignments_f paf,
4398: per_periods_of_service pps
4399: WHERE paa.assignment_action_id = p_assignment_action_id