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

Line 869: pay_assignment_actions act,

865: act1.assignment_action_id prepaid_action_id
866: FROM pay_payroll_actions ppa,
867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,
872: per_all_assignments_f as1
873: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 870: pay_assignment_actions act1,

866: FROM pay_payroll_actions ppa,
867: pay_payroll_actions appa,
868: pay_payroll_actions appa2,
869: pay_assignment_actions act,
870: pay_assignment_actions act1,
871: pay_action_interlocks pai,
872: per_all_assignments_f as1
873: WHERE ppa.payroll_action_id = p_payroll_action_id
874: AND appa.consolidation_set_id = p_consolidation_id

Line 893: pay_assignment_actions act2,

889: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
890:
891: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
892: FROM pay_action_interlocks pai1,
893: pay_assignment_actions act2,
894: pay_payroll_actions appa3
895: WHERE pai1.locked_action_id = act.assignment_action_id
896: AND act2.assignment_action_id= pai1.locking_action_id
897: AND act2.payroll_action_id = appa3.payroll_action_id

Line 904: pay_assignment_actions act2,

900: AND appa3.report_type = 'PYNOARCHIVE')
901:
902: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
903: FROM pay_action_interlocks pai1,
904: pay_assignment_actions act2,
905: pay_payroll_actions appa3
906: WHERE pai1.locked_action_id = act.assignment_action_id
907: AND act2.assignment_action_id= pai1.locking_action_id
908: AND act2.payroll_action_id = appa3.payroll_action_id

Line 967: SELECT pay_assignment_actions_s.NEXTVAL

963: ,l_canonical_end_date) LOOP
964:
965: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
966:
967: SELECT pay_assignment_actions_s.NEXTVAL
968: INTO l_actid
969: FROM dual;
970: --
971: g_index_assact := g_index_assact + 1;

Line 1011: ,pay_assignment_actions prepay_assact

1007: CURSOR csr_prepay_id IS
1008: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
1009: ,run_payact.date_earned date_earned
1010: FROM pay_action_interlocks archive_intlck
1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact

Line 1014: ,pay_assignment_actions run_assact

1010: FROM pay_action_interlocks archive_intlck
1011: ,pay_assignment_actions prepay_assact
1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact
1016: ,pay_assignment_actions archive_assact
1017: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1018: and archive_assact.payroll_action_id = p_payroll_action_id

Line 1016: ,pay_assignment_actions archive_assact

1012: ,pay_payroll_actions prepay_payact
1013: ,pay_action_interlocks prepay_intlck
1014: ,pay_assignment_actions run_assact
1015: ,pay_payroll_actions run_payact
1016: ,pay_assignment_actions archive_assact
1017: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1018: and archive_assact.payroll_action_id = p_payroll_action_id
1019: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
1020: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 1036: ,pay_assignment_actions prepay_assact

1032: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
1033: ,run_payact.date_earned date_earned
1034: ,run_payact.payroll_action_id run_payact_id
1035: FROM pay_action_interlocks archive_intlck
1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact

Line 1039: ,pay_assignment_actions run_assact

1035: FROM pay_action_interlocks archive_intlck
1036: ,pay_assignment_actions prepay_assact
1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact
1041: ,pay_assignment_actions archive_assact
1042: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1043: and archive_assact.payroll_action_id = p_payroll_action_id

Line 1041: ,pay_assignment_actions archive_assact

1037: ,pay_payroll_actions prepay_payact
1038: ,pay_action_interlocks prepay_intlck
1039: ,pay_assignment_actions run_assact
1040: ,pay_payroll_actions run_payact
1041: ,pay_assignment_actions archive_assact
1042: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
1043: and archive_assact.payroll_action_id = p_payroll_action_id
1044: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
1045: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 2570: pay_assignment_actions paa,

2566: pop.org_payment_method_name opm_name,
2567: ppttl.payment_type_name pay_type,
2568: ppp.value value
2569: FROM pay_org_payment_methods_f pop,
2570: pay_assignment_actions paa,
2571: pay_payment_types ppt,
2572: pay_payment_types_tl ppttl,
2573: pay_pre_payments ppp
2574: WHERE paa.assignment_action_id = p_prepay_assact_id

Line 2601: pay_assignment_actions paa,

2597: ppp.value value
2598: FROM pay_external_accounts pea,
2599: pay_org_payment_methods_f pop,
2600: pay_personal_payment_methods_f ppm,
2601: pay_assignment_actions paa,
2602: pay_payment_types ppt,
2603: pay_payment_types_tl ppttl,
2604: pay_pre_payments ppp
2605: WHERE

Line 2815: ,pay_assignment_actions paa

2811: FROM pay_accrual_plans pap
2812: ,pay_element_types_f pet
2813: ,pay_element_links_f pel
2814: ,pay_element_entries_f pee
2815: ,pay_assignment_actions paa
2816: ,pay_payroll_actions ppa
2817: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
2818: AND pel.element_type_id = pet.element_type_id
2819: AND pee.element_link_id = pel.element_link_id

Line 3011: FROM pay_assignment_actions

3007: /* cursor to get he tax unit id (Legal Employer) from assignment action id */
3008:
3009: CURSOR csr_get_le_org_id (p_assignment_action_id NUMBER) IS
3010: SELECT tax_unit_id
3011: FROM pay_assignment_actions
3012: WHERE assignment_action_id = p_assignment_action_id ;
3013:
3014: --------------------------------------------------------
3015:

Line 3062: ,pay_assignment_actions paa

3058: SELECT rrv.result_value val
3059: ,rr.element_entry_id ele_entry_id
3060: FROM pay_run_result_values rrv
3061: ,pay_run_results rr
3062: ,pay_assignment_actions paa
3063: ,pay_payroll_actions ppa
3064: WHERE rrv.input_value_id = p_iv_id
3065: AND rr.element_type_id = p_ele_type_id
3066: AND rr.run_result_id = rrv.run_result_id

Line 3373: FROM pay_assignment_actions paa

3369: -----------------
3370: /* Cursor to retrieve Tax Unit Id for setting context */
3371: CURSOR csr_tax_unit (p_run_assact_id NUMBER) IS
3372: SELECT paa.tax_unit_id
3373: FROM pay_assignment_actions paa
3374: WHERE paa.assignment_action_id = p_run_assact_id;
3375: -----------------
3376: /* Cursor to fetch defined balance id */
3377: CURSOR csr_def_balance(bal_type_id NUMBER, bal_dim_id NUMBER) IS

Line 3555: ,pay_assignment_actions prepay_assact

3551: ,run_assact.assignment_action_id run_assact_id
3552: ,run_payact.payroll_action_id run_payact_id
3553: ,run_payact.payroll_id payroll_id
3554: FROM pay_action_interlocks archive_intlck
3555: ,pay_assignment_actions prepay_assact
3556: ,pay_payroll_actions prepay_payact
3557: ,pay_action_interlocks prepay_intlck
3558: ,pay_assignment_actions run_assact
3559: ,pay_payroll_actions run_payact

Line 3558: ,pay_assignment_actions run_assact

3554: FROM pay_action_interlocks archive_intlck
3555: ,pay_assignment_actions prepay_assact
3556: ,pay_payroll_actions prepay_payact
3557: ,pay_action_interlocks prepay_intlck
3558: ,pay_assignment_actions run_assact
3559: ,pay_payroll_actions run_payact
3560: WHERE archive_intlck.locking_action_id = p_locking_action_id
3561: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
3562: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 3582: ,pay_assignment_actions prepay_assact

3578: ,run_assact.assignment_action_id run_assact_id
3579: ,run_payact.payroll_action_id run_payact_id
3580: ,run_payact.payroll_id payroll_id
3581: FROM pay_action_interlocks archive_intlck
3582: ,pay_assignment_actions prepay_assact
3583: ,pay_payroll_actions prepay_payact
3584: ,pay_action_interlocks prepay_intlck
3585: ,pay_assignment_actions run_assact
3586: ,pay_payroll_actions run_payact

Line 3585: ,pay_assignment_actions run_assact

3581: FROM pay_action_interlocks archive_intlck
3582: ,pay_assignment_actions prepay_assact
3583: ,pay_payroll_actions prepay_payact
3584: ,pay_action_interlocks prepay_intlck
3585: ,pay_assignment_actions run_assact
3586: ,pay_payroll_actions run_payact
3587: WHERE archive_intlck.locking_action_id = p_locking_action_id
3588: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
3589: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id

Line 3593: AND NOT EXISTS (SELECT NULL FROM pay_assignment_actions

3589: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
3590: AND prepay_payact.action_type IN ('U','P')
3591: AND prepay_intlck.locking_action_id = prepay_assact.assignment_action_id
3592: AND run_assact.assignment_action_id = prepay_intlck.locked_action_id
3593: AND NOT EXISTS (SELECT NULL FROM pay_assignment_actions
3594: WHERE payroll_action_id = run_assact.payroll_action_id
3595: AND source_action_id = run_assact.ASSIGNMENT_action_id )
3596: AND run_payact.payroll_action_id = run_assact.payroll_action_id
3597: AND run_payact.action_type IN ('Q', 'R')

Line 3611: ,pay_assignment_actions paa

3607: ppa.effective_date effective_date,
3608: ptp.start_date start_date
3609: FROM per_time_periods ptp
3610: ,pay_payroll_actions ppa
3611: ,pay_assignment_actions paa
3612: WHERE ptp.payroll_id =ppa.payroll_id
3613: AND ppa.payroll_action_id =paa.payroll_action_id
3614: AND paa.assignment_action_id =p_assact_id
3615: AND ppa.payroll_action_id =p_pay_act_id

Line 3621: FROM pay_assignment_actions

3617: -----------------
3618: /* Cursor to retrieve Archive Payroll Action Id */
3619: CURSOR csr_archive_payact(p_assignment_action_id NUMBER) IS
3620: SELECT payroll_action_id
3621: FROM pay_assignment_actions
3622: WHERE assignment_Action_id = p_assignment_action_id;
3623: -----------------
3624: l_archive_payact_id NUMBER;
3625: l_record_count NUMBER;

Line 4284: FROM pay_assignment_actions

4280: /* cursor to get the tax unit id (Legal Employer) from assignment action id */
4281:
4282: CURSOR csr_get_le_org_id (p_assignment_action_id NUMBER) IS
4283: SELECT tax_unit_id
4284: FROM pay_assignment_actions
4285: WHERE assignment_action_id = p_assignment_action_id ;
4286:
4287: --------------------------------------------------------
4288:

Line 4336: ,pay_assignment_actions paa

4332: SELECT rrv.result_value val
4333: ,rr.element_entry_id ele_entry_id
4334: FROM pay_run_result_values rrv
4335: ,pay_run_results rr
4336: ,pay_assignment_actions paa
4337: ,pay_payroll_actions ppa
4338: WHERE rrv.input_value_id = p_iv_id
4339: AND rr.element_type_id = p_ele_type_id
4340: AND rr.run_result_id = rrv.run_result_id

Line 4420: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa

4416:
4417: -- cursor to get the reduced tax rule for the period
4418: CURSOR csr_get_reduced_tax_rule (p_asg_act_id number) IS
4419: SELECT ptp.prd_information1
4420: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa
4421: WHERE paa.ASSIGNMENT_ACTION_ID = p_asg_act_id
4422: AND ppa.payroll_action_id = paa.PAYROLL_ACTION_ID
4423: AND ppa.time_period_id = ptp.time_period_id ;
4424: