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 568: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

564: -- Now caters for spaces in parameter values (so can be used to retrieve
565: -- canonical dates) where the parameter is delimited with pipe chars
566: -- eg. |START_DATE=1999/04/06 00:00:00|
567: IS
568: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
569: l_start_pos NUMBER;
570: l_delimiter varchar2(1):=' ';
571: BEGIN
572: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');

Line 1295: FROM pay_payroll_actions

1291: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1292: 'TEST'),1,1) test_indicator,
1293: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1294: 'UNIQUE_TEST_ID'),1,8) unique_test_id
1295: FROM pay_payroll_actions
1296: WHERE payroll_action_id = p_pact_id;
1297: --
1298: -- End of BUG 5909829 EOY
1299: --

Line 1680: pay_payroll_actions ppa

1676: -- it must be ordered by person_id
1677: --
1678: sqlstr := 'SELECT DISTINCT person_id
1679: FROM per_all_people_f ppf,
1680: pay_payroll_actions ppa
1681: WHERE ppa.payroll_action_id = :payroll_action_id
1682: AND ppa.business_group_id +0= ppf.business_group_id
1683: ORDER BY ppf.person_id';
1684: hr_utility.set_location('Leaving: '||l_proc,40);

Line 1726: FROM pay_payroll_actions

1722: effective_date end_year,
1723: business_group_id,
1724: ltrim(substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
1725: 'ASG_SET'),1,80)) asg_set
1726: FROM pay_payroll_actions
1727: WHERE payroll_action_id = p_payroll_action_id;
1728: --
1729: cursor csr_user_entity(p_entity_name VARCHAR2) IS
1730: SELECT user_entity_id

Line 2239: FROM pay_payroll_actions

2235: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2236: 'TAX_REF'),1,3) tax_dist,
2237: substr(ltrim(substr(pay_gb_eoy_archive.get_parameter(
2238: legislative_parameters,'TAX_REF'),4,11),'/'),1,10) tax_ref --4011263
2239: FROM pay_payroll_actions
2240: WHERE payroll_action_id = p_payroll_action_id;
2241: --
2242: cursor csr_user_entity(p_entity_name VARCHAR2) IS
2243: SELECT user_entity_id

Line 2272: pay_payroll_actions pact

2268: aic.context) tax_dist
2269: FROM ff_archive_item_contexts aic, /* payrolls */
2270: ff_archive_items fai, /* X_START_YEAR */
2271: ff_user_entities fue,
2272: pay_payroll_actions pact
2273: WHERE pact.report_type = 'EOY'
2274: AND pact.report_qualifier = 'GB'
2275: AND pact.action_type = 'X'
2276: AND pact.payroll_action_id = fai.context1

Line 3122: l_action_type pay_payroll_actions.action_type%TYPE;

3118: l_week_53_indicator VARCHAR2(1);
3119: l_week_53_start DATE;
3120: l_number_per_fiscal_yr NUMBER;
3121: l_assignment_message VARCHAR2(80);
3122: l_action_type pay_payroll_actions.action_type%TYPE;
3123: l_ni_arrears NUMBER(15):=0;
3124: l_reportable_ni_archived BOOLEAN := FALSE;
3125:
3126: -- Start of Bug 6271548

Line 3292: pay_payroll_actions pact,

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

Line 3308: from pay_payroll_actions pact,

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

Line 3343: FROM pay_payroll_Actions pact,

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

Line 3456: ,pay_payroll_actions pact

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

Line 3458: ,pay_payroll_actions bact

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

Line 3577: pact PAY_PAYROLL_ACTIONS_PK,

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

Line 3586: pay_payroll_actions pact,

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

Line 3613: pay_payroll_actions pact3

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

Line 3623: pact PAY_PAYROLL_ACTIONS_PK,

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

Line 3634: pay_payroll_actions pact,

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

Line 3661: pay_payroll_actions pact3

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

Line 3758: pay_payroll_actions ppa

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