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 256: pay_assignment_actions.assignment_action_id%TYPE

252: scon VARCHAR2(15));
253: TYPE g_ni_values_typ IS TABLE OF g_ni_values_rec
254: INDEX BY binary_integer;
255: TYPE g_asg_actions_typ IS TABLE OF
256: pay_assignment_actions.assignment_action_id%TYPE
257: INDEX BY binary_integer;
258: TYPE g_date_table_typ IS TABLE OF DATE
259: INDEX BY binary_integer;
260: TYPE g_period_table_typ IS TABLE OF VARCHAR2(30)

Line 307: g_primary_action pay_assignment_actions.assignment_action_id%TYPE;

303: g_masg_active_start per_all_assignments_f.effective_start_date%TYPE;
304: g_masg_active_end per_all_assignments_f.effective_end_date%TYPE;
305: g_masg_tax_ref_num VARCHAR2(10); -- 4011263: length 10 chars
306: g_max_gross_pay NUMBER(15) := NULL;
307: g_primary_action pay_assignment_actions.assignment_action_id%TYPE;
308: g_min_assignment_id per_all_assignments_f.assignment_id%TYPE;
309: g_has_non_extracted_masgs BOOLEAN := FALSE;
310: g_num_actions binary_integer:=0;
311: --

Line 1749: l_actid pay_assignment_actions.assignment_action_id%TYPE;

1745: chunk IN NUMBER) IS
1746: --
1747: l_proc CONSTANT VARCHAR2(35):= g_package||'action_creation';
1748: --
1749: l_actid pay_assignment_actions.assignment_action_id%TYPE;
1750: -- vars for returns from the API:
1751: l_archive_item_id ff_archive_items.archive_item_id%TYPE;
1752: l_ovn NUMBER;
1753: l_some_warning BOOLEAN;

Line 2182: SELECT pay_assignment_actions_s.nextval

2178: -- duplicates
2179: THEN
2180: hr_utility.set_location(l_proc,20);
2181: -- insert an action
2182: SELECT pay_assignment_actions_s.nextval
2183: INTO l_actid
2184: FROM dual;
2185: --
2186: hr_nonrun_asact.insact(l_actid,rec_assignment.assignment_id,

Line 2336: FROM pay_assignment_actions act

2332: AND pact.payroll_action_id = p_pactid;
2333: --
2334: CURSOR get_retry_actions IS
2335: SELECT act.assignment_action_id, act.action_status
2336: FROM pay_assignment_actions act
2337: WHERE act.payroll_action_id = p_payroll_action_id
2338: AND act.action_status = 'M';
2339: --
2340: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS

Line 2342: FROM pay_assignment_actions act1,

2338: AND act.action_status = 'M';
2339: --
2340: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS
2341: SELECT act2.assignment_action_id, asg2.assignment_number, asg1.assignment_number retry_asg_number, pap.full_name, act2.action_status
2342: FROM pay_assignment_actions act1,
2343: pay_assignment_actions act2,
2344: per_all_assignments_f asg1,
2345: per_all_assignments_f asg2,
2346: per_all_people_f pap

Line 2343: pay_assignment_actions act2,

2339: --
2340: CURSOR get_agg_non_retry_actions(p_asg_act_id NUMBER) IS
2341: SELECT act2.assignment_action_id, asg2.assignment_number, asg1.assignment_number retry_asg_number, pap.full_name, act2.action_status
2342: FROM pay_assignment_actions act1,
2343: pay_assignment_actions act2,
2344: per_all_assignments_f asg1,
2345: per_all_assignments_f asg2,
2346: per_all_people_f pap
2347: WHERE act1.assignment_action_id = p_asg_act_id

Line 3163: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;

3159: l_p45_action_seq NUMBER;
3160: l_p45_agg_asg_id NUMBER;
3161: l_p45_final_pay_date DATE;
3162: --
3163: l_last_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
3164: l_last_effective_date DATE;
3165: --
3166: l_paye_eff_date DATE;
3167: l_paye_details_eff_date DATE;

Line 3286: FROM pay_assignment_actions act

3282: g_agg_active_start_eid)), hr_api.g_sot) agg_active_start,
3283: nvl(fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3284: (act.assignment_action_id,
3285: g_agg_active_end_eid)), hr_api.g_eot) agg_active_end
3286: FROM pay_assignment_actions act
3287: WHERE act.assignment_action_id = p_asgactid;
3288: --
3289: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
3290: SELECT min(paaf.effective_start_date) min_active, max(paaf.effective_end_date) max_active

Line 3418: FROM pay_assignment_actions paa,

3414: SELECT /*+ USE_NL(paa, pact, ptp) */
3415: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3416: paa.assignment_action_id),16)),
3417: max(pact.effective_date) effective_date
3418: FROM pay_assignment_actions paa,
3419: pay_payroll_actions pact,
3420: per_time_periods ptp
3421: WHERE paa.assignment_id = p_asgid
3422: AND paa.payroll_action_id = pact.payroll_action_id

Line 3437: pay_assignment_actions act

3433: --
3434: cursor csr_action_details(p_assignment_action_id NUMBER) IS
3435: SELECT pact.action_type
3436: from pay_payroll_actions pact,
3437: pay_assignment_actions act
3438: where act.assignment_action_id = p_assignment_action_id
3439: and act.payroll_action_id = pact.payroll_action_id;
3440: --
3441: cursor csr_person_info(p_person_id NUMBER) IS

Line 3472: pay_assignment_actions act,

3468: WHERE input_value_id = g_process_type_id
3469: AND result_value in ('DY', 'DN', 'DP', 'DR', 'PY')
3470: 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))
3471: FROM pay_payroll_Actions pact,
3472: pay_assignment_actions act,
3473: per_all_assignments_f paf,
3474: pay_run_results prr
3475: WHERE pact.payroll_Action_id = act.payroll_Action_id
3476: AND pact.effective_date BETWEEN g_start_year and g_end_year

Line 3592: ,pay_assignment_actions assact

3588: ,pay_element_entry_values_f ev_cat
3589: ,pay_element_entries_f e_ni
3590: ,pay_element_links_f el_ni
3591: ,pay_payroll_actions pact
3592: ,pay_assignment_actions assact
3593: ,pay_payroll_actions bact
3594: ,per_time_periods bptp
3595: ,per_time_periods pptp
3596: ,pay_assignment_actions bal_assact

Line 3596: ,pay_assignment_actions bal_assact

3592: ,pay_assignment_actions assact
3593: ,pay_payroll_actions bact
3594: ,per_time_periods bptp
3595: ,per_time_periods pptp
3596: ,pay_assignment_actions bal_assact
3597: WHERE bal_assact.assignment_action_id = cp_l_asg_id
3598: AND bal_assact.payroll_action_id = bact.payroll_action_id
3599: AND feed.balance_type_id = bal.balance_type_id
3600: AND bal.balance_name LIKE 'NI%'

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

3711: cursor csr_tax_latest_run(p_assignment_id NUMBER,
3712: p_asg_last_eff_date DATE) IS
3713: -- bug 889323 ensure the last action included PAYE Details result
3714: -- bug 1236784 ignore reversal/reversed runs
3715: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3716: pact PAY_PAYROLL_ACTIONS_PK,
3717: r2 PAY_RUN_RESULTS_N50)
3718: USE_NL(assact2, pact, r2) */
3719: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')

Line 3724: FROM pay_assignment_actions assact2,

3720: ||r2.source_type||
3721: lpad(to_char(r2.run_result_id),19,'0')),17)) rr_id,
3722: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3723: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3724: FROM pay_assignment_actions assact2,
3725: pay_payroll_actions pact,
3726: pay_run_results r2
3727: WHERE assact2.assignment_id = p_assignment_id
3728: AND r2.element_type_id+0 = g_paye_details_id

Line 3752: pay_assignment_actions assact3,

3748: AND pact.effective_date <= p_asg_last_eff_date
3749: AND NOT EXISTS(
3750: SELECT '1'
3751: FROM pay_action_interlocks pai,
3752: pay_assignment_actions assact3,
3753: pay_payroll_actions pact3
3754: WHERE pai.locked_action_id = assact2.assignment_action_id
3755: AND pai.locking_action_id = assact3.assignment_action_id
3756: AND pact3.payroll_action_id = assact3.payroll_action_id

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

3758: AND assact3.action_status = 'C');
3759: --
3760: cursor csr_tax_latest_paye_run(p_assignment_id NUMBER,
3761: p_asg_last_eff_date DATE) IS
3762: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3763: pact PAY_PAYROLL_ACTIONS_PK,
3764: r2 PAY_RUN_RESULTS_N50)
3765: USE_NL(assact2, pact, r2) */
3766: to_number(substr(max(lpad(to_char(assact2.action_sequence),15,'0')

Line 3773: FROM pay_assignment_actions assact2,

3769: fnd_date.canonical_to_date(substr(max(lpad(to_char(assact2.action_sequence),15,'0')||
3770: fnd_date.date_to_canonical(pact.effective_date)),16)) eff_date
3771: -- to_number(substr(max(lpad(assact2.action_sequence,15,'0')||
3772: -- r2.run_result_id),16))
3773: FROM pay_assignment_actions assact2,
3774: pay_payroll_actions pact,
3775: pay_run_results r2
3776: WHERE assact2.assignment_id = p_assignment_id
3777: AND r2.element_type_id+0 = g_paye_element_id

Line 3801: pay_assignment_actions assact3,

3797: AND pact.effective_date <= p_asg_last_eff_date
3798: AND NOT EXISTS(
3799: SELECT '1'
3800: FROM pay_action_interlocks pai,
3801: pay_assignment_actions assact3,
3802: pay_payroll_actions pact3
3803: WHERE pai.locked_action_id = assact2.assignment_action_id
3804: AND pai.locking_action_id = assact3.assignment_action_id
3805: AND pact3.payroll_action_id = assact3.payroll_action_id

Line 3898: pay_assignment_actions paa,

3894: CURSOR csr_get_final_payment_date(c_asg_action_id NUMBER) IS
3895: SELECT ppa.effective_date
3896: FROM ff_user_entities fue,
3897: ff_archive_items fai,
3898: pay_assignment_actions paa,
3899: pay_payroll_actions ppa
3900: WHERE fue.user_entity_name = 'X_P45_FINAL_PAYMENT_ACTION'
3901: AND fue.user_entity_id = fai.user_entity_id
3902: AND fai.context1 = c_asg_action_id