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_PAYROLL_ACTIONS

Line 8: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

4: ------------------------------- GLOBALS -------------------------------------
5: --'
6: g_package CONSTANT VARCHAR2(20):= 'pay_gb_eoy_archive.';
7: -- Globals populated by archinit procedure or action_creation proc
8: g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
9: g_start_year DATE;
10: g_end_year DATE;
11: g_business_group_id hr_organization_units.business_group_id%TYPE;
12: g_permit_number VARCHAR2(12);

Line 592: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

588: -- Now caters for spaces in parameter values (so can be used to retrieve
589: -- canonical dates) where the parameter is delimited with pipe chars
590: -- eg. |START_DATE=1999/04/06 00:00:00|
591: IS
592: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
593: l_start_pos NUMBER;
594: l_delimiter varchar2(1):=' ';
595: BEGIN
596: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

Line 1321: FROM pay_payroll_actions

1317: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1318: 'TEST'),1,1) test_indicator,
1319: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1320: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1321: FROM pay_payroll_actions
1322: WHERE payroll_action_id = p_pact_id;
1323: --
1324: -- End of BUG 5909829 EOY
1325: --

Line 1727: pay_payroll_actions ppa

1723: -- it must be ordered by person_id
1724: --
1725: sqlstr := 'SELECT DISTINCT person_id
1726: FROM per_all_people_f ppf,
1727: pay_payroll_actions ppa
1728: WHERE ppa.payroll_action_id = :payroll_action_id
1729: AND ppa.business_group_id +0= ppf.business_group_id
1730: ORDER BY ppf.person_id';
1731: hr_utility.set_location('Leaving: '||l_proc,40);

Line 1773: FROM pay_payroll_actions

1769: effective_date end_year,
1770: business_group_id,
1771: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1772: 'ASG_SET'),1,80)) asg_set
1773: FROM pay_payroll_actions
1774: WHERE payroll_action_id = p_payroll_action_id;
1775: --
1776: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1777: SELECT user_entity_id

Line 2288: FROM pay_payroll_actions

2284: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2285: 'TAX_REF'),1,3) tax_dist,
2286: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2287: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2288: FROM pay_payroll_actions
2289: WHERE payroll_action_id = p_payroll_action_id;
2290: --
2291: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2292: SELECT user_entity_id

Line 2321: pay_payroll_actions pact

2317: aic.context) tax_dist
2318: FROM ff_archive_item_contexts aic, /* payrolls */
2319: ff_archive_items fai, /* X_START_YEAR */
2320: ff_user_entities fue,
2321: pay_payroll_actions pact
2322: WHERE pact.report_type = 'EOY'
2323: AND pact.report_qualifier = 'GB'
2324: AND pact.action_type = 'X'
2325: AND pact.payroll_action_id = fai.context1

Line 3242: l_action_type pay_payroll_actions.action_type%TYPE;

3238: l_week_53_indicator VARCHAR2(1);
3239: l_week_53_start DATE;
3240: l_number_per_fiscal_yr NUMBER;
3241: l_assignment_message VARCHAR2(80);
3242: l_action_type pay_payroll_actions.action_type%TYPE;
3243: l_ni_arrears NUMBER(15):=0;
3244: l_reportable_ni_archived BOOLEAN := FALSE;
3245:
3246: -- Start of Bug 6271548

Line 3419: pay_payroll_actions pact,

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
3423: AND pact.time_period_id = ptp.time_period_id

Line 3436: from pay_payroll_actions pact,

3432: -- Retrieve action type info from assignment ation
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: --

Line 3471: FROM pay_payroll_Actions pact,

3467: FROM pay_run_result_values prrv
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

Line 3591: ,pay_payroll_actions pact

3587: ,pay_element_entry_values_f ev_scon
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

Line 3593: ,pay_payroll_actions bact

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
3597: WHERE bal_assact.assignment_action_id = cp_l_asg_id

Line 3716: pact PAY_PAYROLL_ACTIONS_PK,

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')
3720: ||r2.source_type||

Line 3725: pay_payroll_actions pact,

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
3729: AND r2.assignment_action_id = assact2.assignment_action_id

Line 3753: pay_payroll_actions pact3

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
3757: AND pact3.action_type = 'V'

Line 3763: pact PAY_PAYROLL_ACTIONS_PK,

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')
3767: ||r2.source_type||

Line 3774: pay_payroll_actions pact,

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
3778: AND r2.assignment_action_id = assact2.assignment_action_id

Line 3802: pay_payroll_actions pact3

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
3806: AND pact3.action_type = 'V'

Line 3899: pay_payroll_actions ppa

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
3903: AND fai.value = paa.assignment_action_id