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 290: FROM pay_assignment_actions paa_init,

286: p_end_date DATE,
287: p_consolidation_set_id NUMBER) IS
288: SELECT paa_init.assignment_id,
289: paa_init.assignment_action_id
290: FROM pay_assignment_actions paa_init,
291: pay_payroll_actions ppa_init,
292: per_all_assignments_f paf
293: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
294: AND ppa_init.action_type='I'

Line 309: FROM pay_assignment_actions paa_arch

305: ,'I'
306: ,ppa_init.effective_date
307: )
308: AND NOT EXISTS (SELECT NULL
309: FROM pay_assignment_actions paa_arch
310: ,pay_payroll_actions ppa_arch
311: ,pay_action_interlocks intk
312: WHERE paa_arch.payroll_action_id = ppa_arch.payroll_action_id
313: AND intk.locked_action_id = paa_init.assignment_action_id

Line 370: SELECT pay_assignment_actions_s.NEXTVAL

366: END IF;
367:
368: FOR i in csr_bal_init (l_payroll_id,l_canonical_start_date,l_canonical_end_date,l_consolidation_set)
369: LOOP
370: SELECT pay_assignment_actions_s.NEXTVAL
371: INTO l_actid
372: FROM dual;
373:
374: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE 'I' ASSIGNMENT ACTION

Line 454: ,pay_assignment_actions paa

450: FROM pay_accrual_plans pap
451: ,pay_element_types_f pet
452: ,pay_element_links_f pel
453: ,pay_element_entries_f pee
454: ,pay_assignment_actions paa
455: ,pay_payroll_actions ppa
456: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
457: AND pel.element_type_id = pet.element_type_id
458: AND pee.element_link_id = pel.element_link_id

Line 645: FROM pay_assignment_actions paa

641: ,pet.reporting_name reporting_name
642: ,decode(pet.processing_type,'R',greatest(pab.date_start,PTP.START_DATE),pab.date_start) start_date
643: ,decode(pet.processing_type,'R',least(pab.date_end,PTP.END_DATE),pab.date_end) end_date
644: ,decode(pet.processing_type,'R',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours)) absence_days
645: FROM pay_assignment_actions paa
646: ,pay_payroll_actions ppa
647: ,pay_run_results prr
648: ,pay_run_result_values prrv
649: ,per_time_periods ptp

Line 1171: ,pay_assignment_actions paa

1167: )
1168: IS
1169: select count(paa.assignment_action_id)
1170: from pay_payroll_actions ppa
1171: ,pay_assignment_actions paa
1172: ,pay_action_interlocks pal
1173: where pal.locking_action_id=p_prepayment_lcking_id
1174: and paa.assignment_action_id=pal.locked_action_id
1175: and ppa.payroll_action_id=paa.payroll_action_id

Line 1187: ,pay_assignment_actions paa

1183: select paa.assignment_action_id assignment_action_id
1184: ,ppa.date_earned date_earned
1185: ,ppa.effective_date effective_date
1186: from pay_payroll_actions ppa
1187: ,pay_assignment_actions paa
1188: ,pay_action_interlocks pal
1189: where pal.locking_action_id=p_prepayment_lcking_id
1190: and paa.assignment_action_id=pal.locked_action_id
1191: and ppa.payroll_action_id=paa.payroll_action_id

Line 1466: ,pay_assignment_actions paa

1462: SELECT hoi.org_information1
1463: FROM hr_soft_coding_keyflex hsck
1464: ,hr_organization_information hoi
1465: ,per_assignments_f paaf
1466: ,pay_assignment_actions paa
1467: ,pay_payroll_actions ppa
1468: WHERE paa.assignment_action_id = p_assactid
1469: AND paa.payroll_action_id = ppa.payroll_action_id
1470: AND paa.assignment_id = paaf.assignment_id

Line 1483: FROM pay_assignment_actions

1479:
1480: CURSOR csr_tax_unit_id
1481: IS
1482: SELECT tax_unit_id
1483: FROM pay_assignment_actions
1484: WHERE assignment_action_id = p_curr_pymt_ass_act_id;
1485: --
1486:
1487:

Line 1839: ,pay_assignment_actions paa

1835: ,pep.person_id person_id
1836: ,con.contact_person_id contact
1837: FROM per_assignments_f asg
1838: ,per_people_f pep
1839: ,pay_assignment_actions paa
1840: ,per_contact_relationships con
1841: WHERE asg.PERSON_ID=pep.person_id
1842: AND asg.assignment_id=paa.assignment_id
1843: AND paa.assignment_action_id= p_assignment_action_id

Line 1863: ,pay_assignment_actions paa

1859: select DISTINCT hoi.organization_id source_id
1860: from hr_organization_units hoi
1861: ,hr_soft_coding_keyflex scf
1862: ,per_assignments_f asg
1863: ,pay_assignment_actions paa
1864: where asg.assignment_id=paa.assignment_id
1865: and paa.assignment_action_id=p_assignment_action_id
1866: and asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID
1867: and hoi.ORGANIZATION_ID=scf.segment2

Line 2446: ,pay_assignment_actions paa

2442: SELECT DISTINCT hoi.organization_id source_id
2443: FROM hr_organization_units hoi
2444: ,hr_soft_coding_keyflex scf
2445: ,per_assignments_f asg
2446: ,pay_assignment_actions paa
2447: WHERE asg.assignment_id=paa.assignment_id
2448: AND paa.assignment_action_id=p_assignment_action_id
2449: AND asg.SOFT_CODING_KEYFLEX_ID=scf.SOFT_CODING_KEYFLEX_ID
2450: AND hoi.ORGANIZATION_ID=scf.segment4

Line 2476: ,pay_assignment_actions paa

2472: ,pep.per_information9 ESI_Number
2473: ,pep.person_id person_id
2474: FROM per_assignments_f asg
2475: ,per_people_f pep
2476: ,pay_assignment_actions paa
2477: WHERE asg.PERSON_ID=pep.person_id
2478: AND asg.assignment_id=paa.assignment_id
2479: AND paa.assignment_action_id= p_assignment_action_id
2480: AND p_payroll_date BETWEEN pep.effective_start_date AND pep.effective_end_date

Line 3409: ,pay_assignment_actions paa

3405: SELECT DISTINCT pay_in_prof_tax_pkg.get_state(hoi.organization_id) jurisdiction_code
3406: FROM hr_organization_units hoi
3407: ,hr_soft_coding_keyflex scf
3408: ,per_assignments_f asg
3409: ,pay_assignment_actions paa
3410: WHERE asg.assignment_id = paa.assignment_id
3411: AND paa.assignment_action_id = p_assignment_action_id
3412: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
3413: AND hoi.organization_id = scf.segment3

Line 3430: ,pay_assignment_actions paa

3426: ,asg.effective_end_date
3427: FROM hr_organization_units hoi
3428: ,hr_soft_coding_keyflex scf
3429: ,per_assignments_f asg
3430: ,pay_assignment_actions paa
3431: WHERE asg.assignment_id = paa.assignment_id
3432: AND paa.assignment_action_id = p_assignment_action_id
3433: AND asg.soft_coding_keyflex_id = scf.soft_coding_keyflex_id
3434: AND hoi.organization_id = scf.segment3

Line 3449: ,pay_assignment_actions paa

3445: SELECT hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title) Employee_Name
3446: ,pep.person_id person_id
3447: FROM per_assignments_f asg
3448: ,per_people_f pep
3449: ,pay_assignment_actions paa
3450: WHERE asg.person_id = pep.person_id
3451: AND asg.assignment_id = paa.assignment_id
3452: AND paa.assignment_action_id = p_assignment_action_id
3453: AND p_payroll_date BETWEEN pep.effective_start_date AND pep.effective_end_date

Line 4039: FROM pay_assignment_actions paa_arch

4035: ,paa_init.assignment_action_id init_assignment_action_id
4036: ,ppa_init.payroll_action_id init_payroll_action_id
4037: ,ppa_init.effective_date init_effective_date
4038: ,paa_arch.assignment_id
4039: FROM pay_assignment_actions paa_arch
4040: ,pay_action_interlocks intk
4041: ,pay_assignment_actions paa_init
4042: ,pay_payroll_actions ppa_init
4043: WHERE paa_arch.assignment_action_id = p_init_arch_action_id

Line 4041: ,pay_assignment_actions paa_init

4037: ,ppa_init.effective_date init_effective_date
4038: ,paa_arch.assignment_id
4039: FROM pay_assignment_actions paa_arch
4040: ,pay_action_interlocks intk
4041: ,pay_assignment_actions paa_init
4042: ,pay_payroll_actions ppa_init
4043: WHERE paa_arch.assignment_action_id = p_init_arch_action_id
4044: AND intk.locking_action_id = paa_arch.assignment_action_id
4045: AND intk.locked_action_id = paa_init.assignment_action_id

Line 4068: FROM pay_assignment_actions paa_arch_chd

4064: ,ptp.end_date period_end_date
4065: ,ptp.time_period_id
4066: ,ptp.start_date period_start_date
4067: ,ptp.regular_payment_date
4068: FROM pay_assignment_actions paa_arch_chd
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run

Line 4069: ,pay_assignment_actions paa_arch_mst

4065: ,ptp.time_period_id
4066: ,ptp.start_date period_start_date
4067: ,ptp.regular_payment_date
4068: FROM pay_assignment_actions paa_arch_chd
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run

Line 4070: ,pay_assignment_actions paa_pre

4066: ,ptp.start_date period_start_date
4067: ,ptp.regular_payment_date
4068: FROM pay_assignment_actions paa_arch_chd
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre

Line 4072: ,pay_assignment_actions paa_run

4068: FROM pay_assignment_actions paa_arch_chd
4069: ,pay_assignment_actions paa_arch_mst
4070: ,pay_assignment_actions paa_pre
4071: ,pay_action_interlocks pai_pre
4072: ,pay_assignment_actions paa_run
4073: ,pay_action_interlocks pai_run
4074: ,pay_payroll_actions ppa_pre
4075: ,pay_payroll_actions ppa_run
4076: ,per_time_periods ptp

Line 4100: FROM pay_assignment_actions paa_run2

4096: -- Get the highest in sequence for this payslip
4097: AND paa_run.action_sequence =
4098: (
4099: SELECT MAX(paa_run2.action_sequence)
4100: FROM pay_assignment_actions paa_run2
4101: ,pay_action_interlocks pai_run2
4102: WHERE pai_run2.locking_action_id = paa_arch_chd.assignment_action_id
4103: AND pai_run2.locked_action_id = paa_run2.assignment_action_id
4104: );

Line 4113: ,pay_assignment_actions paa

4109: )
4110: IS
4111: select count(paa.assignment_action_id)
4112: from pay_payroll_actions ppa
4113: ,pay_assignment_actions paa
4114: ,pay_action_interlocks pal
4115: where pal.locking_action_id=p_prepayment_lcking_id
4116: and paa.assignment_action_id=pal.locked_action_id
4117: and ppa.payroll_action_id=paa.payroll_action_id

Line 4131: ,pay_assignment_actions paa

4127: IS
4128: select paa.assignment_action_id
4129: ,ppa.date_earned
4130: from pay_payroll_actions ppa
4131: ,pay_assignment_actions paa
4132: ,pay_action_interlocks pal
4133: where pal.locking_action_id=p_prepayment_lcking_id
4134: and paa.assignment_action_id=pal.locked_action_id
4135: and ppa.payroll_action_id=paa.payroll_action_id

Line 4148: FROM pay_payroll_actions ppa,pay_assignment_actions paa,

4144: ,c_assignment_id NUMBER
4145: ,c_payroll_date date)
4146: IS
4147: SELECT paa.assignment_action_id
4148: FROM pay_payroll_actions ppa,pay_assignment_actions paa,
4149: pay_action_interlocks pai1,pay_action_interlocks pai2
4150:
4151: WHERE ppa.PAYROLL_ACTION_ID = paa.PAYROLL_ACTION_ID
4152: AND paa.ASSIGNMENT_ID = c_assignment_id

Line 4170: pay_assignment_actions paa,

4166: CURSOR csr_payment_date(p_assignment_action_id NUMBER)
4167: IS
4168: SELECT pps.actual_termination_date
4169: FROM pay_payroll_actions ppa,
4170: pay_assignment_actions paa,
4171: per_time_periods ptp,
4172: per_all_assignments_f paf,
4173: per_periods_of_service pps
4174: WHERE paa.assignment_action_id = p_assignment_action_id