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

Line 232: pay_assignment_actions.assignment_action_id%TYPE

228: scon VARCHAR2(15));
229: TYPE g_ni_values_typ IS TABLE OF g_ni_values_rec
230: INDEX BY binary_integer;
231: TYPE g_asg_actions_typ IS TABLE OF
232: pay_assignment_actions.assignment_action_id%TYPE
233: INDEX BY binary_integer;
234: TYPE g_date_table_typ IS TABLE OF DATE
235: INDEX BY binary_integer;
236: TYPE g_period_table_typ IS TABLE OF VARCHAR2(30)

Line 283: g_primary_action pay_assignment_actions.assignment_action_id%TYPE;

279: g_masg_active_start per_all_assignments_f.effective_start_date%TYPE;
280: g_masg_active_end per_all_assignments_f.effective_end_date%TYPE;
281: g_masg_tax_ref_num VARCHAR2(10); -- 4011263: length 10 chars
282: g_max_gross_pay NUMBER(15) := NULL;
283: g_primary_action pay_assignment_actions.assignment_action_id%TYPE;
284: g_min_assignment_id per_all_assignments_f.assignment_id%TYPE;
285: g_has_non_extracted_masgs BOOLEAN := FALSE;
286: g_num_actions binary_integer:=0;
287: --

Line 1702: l_actid pay_assignment_actions.assignment_action_id%TYPE;

1698: chunk IN NUMBER) IS
1699: --
1700: l_proc CONSTANT VARCHAR2(35):= g_package||'action_creation';
1701: --
1702: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1703: -- vars for returns from the API:
1704: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1705: l_ovn NUMBER;
1706: l_some_warning BOOLEAN;

Line 2133: SELECT pay_assignment_actions_s.nextval

2129: -- duplicates
2130: THEN
2131: hr_utility.set_location(l_proc,20);
2132: -- insert an action
2133: SELECT pay_assignment_actions_s.nextval
2134: INTO l_actid
2135: FROM dual;
2136: --
2137: hr_nonrun_asact.insact(l_actid,rec_assignment.assignment_id,

Line 2287: FROM pay_assignment_actions act

2283: AND pact.payroll_action_id = p_pactid;
2284: --
2285: CURSOR get_retry_actions IS
2286: SELECT act.assignment_action_id, act.action_status
2287: FROM pay_assignment_actions act
2288: WHERE act.payroll_action_id = p_payroll_action_id
2289: AND act.action_status = 'M';
2290: --
2291: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS

Line 2293: FROM pay_assignment_actions act1,

2289: AND act.action_status = 'M';
2290: --
2291: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS
2292: SELECT act2.assignment_action_id, asg2.assignment_number, asg1.assignment_number retry_asg_number, pap.full_name, act2.action_status
2293: FROM pay_assignment_actions act1,
2294: pay_assignment_actions act2,
2295: per_all_assignments_f asg1,
2296: per_all_assignments_f asg2,
2297: per_all_people_f pap

Line 2294: pay_assignment_actions act2,

2290: --
2291: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS
2292: SELECT act2.assignment_action_id, asg2.assignment_number, asg1.assignment_number retry_asg_number, pap.full_name, act2.action_status
2293: FROM pay_assignment_actions act1,
2294: pay_assignment_actions act2,
2295: per_all_assignments_f asg1,
2296: per_all_assignments_f asg2,
2297: per_all_people_f pap
2298: WHERE act1.assignment_action_id = p_asg_act_id

Line 3048: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

3044: l_p45_action_seq NUMBER;
3045: l_p45_agg_asg_id NUMBER;
3046: l_p45_final_pay_date DATE;
3047: --
3048: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3049: l_last_effective_date DATE;
3050: --
3051: l_paye_eff_date DATE;
3052: l_paye_details_eff_date DATE;

Line 3159: FROM pay_assignment_actions act

3155: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3156: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3157: (act.assignment_action_id,
3158: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3159: FROM pay_assignment_actions act
3160: WHERE act.assignment_action_id = p_asgactid;
3161: --
3162: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3163: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active

Line 3291: FROM pay_assignment_actions paa,

3287: SELECT /*+ USE_NL(paa, pact, ptp) */
3288: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3289: paa.assignment_action_id),16)),
3290: max(pact.effective_date) effective_date
3291: FROM pay_assignment_actions paa,
3292: pay_payroll_actions pact,
3293: per_time_periods ptp
3294: WHERE paa.assignment_id = p_asgid
3295: AND paa.payroll_action_id = pact.payroll_action_id

Line 3309: pay_assignment_actions act

3305: --
3306: cursor csr_action_details(p_assignment_action_id NUMBER) IS
3307: SELECT pact.action_type
3308: from pay_payroll_actions pact,
3309: pay_assignment_actions act
3310: where act.assignment_action_id = p_assignment_action_id
3311: and act.payroll_action_id = pact.payroll_action_id;
3312: --
3313: cursor csr_person_info(p_person_id NUMBER) IS

Line 3344: pay_assignment_actions act,

3340: WHERE input_value_id = g_process_type_id
3341: AND result_value in ('DY', 'DN', 'DP', 'DR', 'PY')
3342: AND run_result_id = (SELECT to_number(substr(max(lpad(to_char(act.action_sequence),15,'0')|| lpad(to_char(prr.run_result_id),19,'0')),16))
3343: FROM pay_payroll_Actions pact,
3344: pay_assignment_actions act,
3345: per_all_assignments_f paf,
3346: pay_run_results prr
3347: WHERE pact.payroll_Action_id = act.payroll_Action_id
3348: AND pact.effective_date BETWEEN g_start_year and g_end_year

Line 3457: ,pay_assignment_actions assact

3453: ,pay_element_entry_values_f ev_cat
3454: ,pay_element_entries_f e_ni
3455: ,pay_element_links_f el_ni
3456: ,pay_payroll_actions pact
3457: ,pay_assignment_actions assact
3458: ,pay_payroll_actions bact
3459: ,per_time_periods bptp
3460: ,per_time_periods pptp
3461: ,pay_assignment_actions bal_assact

Line 3461: ,pay_assignment_actions bal_assact

3457: ,pay_assignment_actions assact
3458: ,pay_payroll_actions bact
3459: ,per_time_periods bptp
3460: ,per_time_periods pptp
3461: ,pay_assignment_actions bal_assact
3462: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3463: AND bal_assact.payroll_action_id = bact.payroll_action_id
3464: AND feed.balance_type_id = bal.balance_type_id
3465: AND bal.balance_name LIKE 'NI%'

Line 3576: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,

3572: cursor csr_tax_latest_run(p_assignment_id NUMBER,
3573: p_asg_last_eff_date DATE) IS
3574: -- bug 889323 ensure the last action included PAYE Details result
3575: -- bug 1236784 ignore reversal/reversed runs
3576: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3577: pact PAY_PAYROLL_ACTIONS_PK,
3578: r2 PAY_RUN_RESULTS_N50)
3579: USE_NL(assact2, pact, r2) */
3580: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')

Line 3585: FROM pay_assignment_actions assact2,

3581: ||r2.source_type||
3582: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3583: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3584: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3585: FROM pay_assignment_actions assact2,
3586: pay_payroll_actions pact,
3587: pay_run_results r2
3588: WHERE assact2.assignment_id = p_assignment_id
3589: AND r2.element_type_id+0 = g_paye_details_id

Line 3612: pay_assignment_actions assact3,

3608: AND pact.effective_date <= p_asg_last_eff_date
3609: AND NOT EXISTS(
3610: SELECT '1'
3611: FROM pay_action_interlocks pai,
3612: pay_assignment_actions assact3,
3613: pay_payroll_actions pact3
3614: WHERE pai.locked_action_id = assact2.assignment_action_id
3615: AND pai.locking_action_id = assact3.assignment_action_id
3616: AND pact3.payroll_action_id = assact3.payroll_action_id

Line 3622: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,

3618: AND assact3.action_status = 'C');
3619: --
3620: cursor csr_tax_latest_paye_run(p_assignment_id NUMBER,
3621: p_asg_last_eff_date DATE) IS
3622: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3623: pact PAY_PAYROLL_ACTIONS_PK,
3624: r2 PAY_RUN_RESULTS_N50)
3625: USE_NL(assact2, pact, r2) */
3626: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')

Line 3633: FROM pay_assignment_actions assact2,

3629: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3630: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3631: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3632: -- r2.run_result_id),16))
3633: FROM pay_assignment_actions assact2,
3634: pay_payroll_actions pact,
3635: pay_run_results r2
3636: WHERE assact2.assignment_id = p_assignment_id
3637: AND r2.element_type_id+0 = g_paye_element_id

Line 3660: pay_assignment_actions assact3,

3656: AND pact.effective_date <= p_asg_last_eff_date
3657: AND NOT EXISTS(
3658: SELECT '1'
3659: FROM pay_action_interlocks pai,
3660: pay_assignment_actions assact3,
3661: pay_payroll_actions pact3
3662: WHERE pai.locked_action_id = assact2.assignment_action_id
3663: AND pai.locking_action_id = assact3.assignment_action_id
3664: AND pact3.payroll_action_id = assact3.payroll_action_id

Line 3757: pay_assignment_actions paa,

3753: CURSOR csr_get_final_payment_date(c_asg_action_id NUMBER) IS
3754: SELECT ppa.effective_date
3755: FROM ff_user_entities fue,
3756: ff_archive_items fai,
3757: pay_assignment_actions paa,
3758: pay_payroll_actions ppa
3759: WHERE fue.user_entity_name = 'X_P45_FINAL_PAYMENT_ACTION'
3760: AND fue.user_entity_id = fai.user_entity_id
3761: AND fai.context1 = c_asg_action_id