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_P45_PKG dependencies on PAY_GB_EOY_ARCHIVE

Line 932: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);

928: OPEN get_aggregation_end;
929: FETCH get_aggregation_end INTO l_aggregation_end;
930: CLOSE get_aggregation_end;
931: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
932: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
933: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
934: --
935: -- 5144343: Get aggregated action within the aggregation period only
936: open agg_latest_action(X_PERSON_ID, least(X_TRANSFER_DATE, l_aggregation_end),

Line 933: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);

929: FETCH get_aggregation_end INTO l_aggregation_end;
930: CLOSE get_aggregation_end;
931: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
932: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
933: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
934: --
935: -- 5144343: Get aggregated action within the aggregation period only
936: open agg_latest_action(X_PERSON_ID, least(X_TRANSFER_DATE, l_aggregation_end),
937: X_TAX_REFERENCE,

Line 1428: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1424: CURSOR csr_get_p45_start_end_date(p_payroll_action_id NUMBER) IS
1425: SELECT
1426: start_date,
1427: fnd_date.canonical_to_date
1428: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1429: 'DATE_TO')) end_date
1430: FROM pay_payroll_actions
1431: WHERE payroll_action_id = p_payroll_action_id;
1432:

Line 1440: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1436:
1437: CURSOR csr_get_p45_EDI_start_end_date(p_payroll_action_id NUMBER) IS
1438: SELECT
1439: fnd_date.canonical_to_date
1440: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1441: 'DATE_FROM')) start_date,
1442: fnd_date.canonical_to_date
1443: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1444: 'END_DATE')) end_date

Line 1443: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1439: fnd_date.canonical_to_date
1440: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1441: 'DATE_FROM')) start_date,
1442: fnd_date.canonical_to_date
1443: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1444: 'END_DATE')) end_date
1445: FROM pay_payroll_actions
1446: WHERE payroll_action_id = p_payroll_action_id;
1447: -- End of BUG 5671777-11

Line 2082: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2078: l_inc_asg_index NUMBER;
2079: --
2080: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2081: SELECT
2082: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2083: 'PAYROLL_ID')) payroll_id,
2084: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2085: 'TAX_REF'),1,20) tax_ref,
2086: start_date,

Line 2084: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2080: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2081: SELECT
2082: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2083: 'PAYROLL_ID')) payroll_id,
2084: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2085: 'TAX_REF'),1,20) tax_ref,
2086: start_date,
2087: effective_date,
2088: fnd_date.canonical_to_date

Line 2089: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

2085: 'TAX_REF'),1,20) tax_ref,
2086: start_date,
2087: effective_date,
2088: fnd_date.canonical_to_date
2089: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
2090: 'DATE_TO')) end_date,
2091: business_group_id
2092: FROM pay_payroll_actions
2093: WHERE payroll_action_id = p_payroll_action_id;

Line 2145: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)

2141: per_assignment_status_types past
2142: WHERE a.assignment_id = a3.assignment_id
2143: AND a3.assignment_status_type_id = past.assignment_status_type_id
2144: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2145: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)
2146: AND a3.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_term_date));
2147:
2148: --
2149: /* Fix performance bug by split cursor into 2 */

Line 2146: AND a3.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_term_date));

2142: WHERE a.assignment_id = a3.assignment_id
2143: AND a3.assignment_status_type_id = past.assignment_status_type_id
2144: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2145: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)
2146: AND a3.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_term_date));
2147:
2148: --
2149: /* Fix performance bug by split cursor into 2 */
2150: cursor csr_all_assignments is

Line 2620: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2616: AND business_group_id IS NULL;
2617: --
2618: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2619: SELECT
2620: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2621: 'PAYROLL_ID')) payroll_id,
2622: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2623: 'CHAR_ERROR'),
2624: 'Y','TRUE','N','FALSE') check_chars,

Line 2622: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2618: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2619: SELECT
2620: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2621: 'PAYROLL_ID')) payroll_id,
2622: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2623: 'CHAR_ERROR'),
2624: 'Y','TRUE','N','FALSE') check_chars,
2625: effective_date
2626: FROM pay_payroll_actions

Line 2831: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

2827: l_final_process_date date;
2828: --
2829: cursor csr_asg_act_info(p_asgactid NUMBER) IS
2830: SELECT act.assignment_id,
2831: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
2832: (act.assignment_action_id,
2833: g_termination_date_eid)) term_date,
2834: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
2835: g_tax_ref_transfer_eid) tax_ref_transfer

Line 2834: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,

2830: SELECT act.assignment_id,
2831: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
2832: (act.assignment_action_id,
2833: g_termination_date_eid)) term_date,
2834: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
2835: g_tax_ref_transfer_eid) tax_ref_transfer
2836: FROM pay_assignment_actions act
2837: WHERE act.assignment_action_id = p_asgactid;
2838: --

Line 3506: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3502: AND business_group_id IS NULL;
3503: --
3504: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
3505: SELECT
3506: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3507: 'PAYROLL_ID')) payroll_id,
3508: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3509: 'TAX_REF'),1,20) tax_ref,
3510: fnd_date.canonical_to_date

Line 3508: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

3504: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
3505: SELECT
3506: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3507: 'PAYROLL_ID')) payroll_id,
3508: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3509: 'TAX_REF'),1,20) tax_ref,
3510: fnd_date.canonical_to_date
3511: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
3512: 'DATE_FROM')) start_date,

Line 3511: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

3507: 'PAYROLL_ID')) payroll_id,
3508: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
3509: 'TAX_REF'),1,20) tax_ref,
3510: fnd_date.canonical_to_date
3511: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
3512: 'DATE_FROM')) start_date,
3513: effective_date end_date,
3514: business_group_id
3515: FROM pay_payroll_actions

Line 4055: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)

4051: per_assignment_status_types past
4052: where a.assignment_status_type_id = past.assignment_status_type_id
4053: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4054: and a.assignment_id = c_assignment_id
4055: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)
4056: and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_agg_assignment_id, c_tax_ref, c_effective_date)
4057: ;
4058:
4059: cursor csr_aggr_paye_flag (c_person_id number,

Line 4056: and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_agg_assignment_id, c_tax_ref, c_effective_date)

4052: where a.assignment_status_type_id = past.assignment_status_type_id
4053: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4054: and a.assignment_id = c_assignment_id
4055: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)
4056: and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_agg_assignment_id, c_tax_ref, c_effective_date)
4057: ;
4058:
4059: cursor csr_aggr_paye_flag (c_person_id number,
4060: c_effective_date date) is