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 1017: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);

1013: OPEN get_aggregation_end;
1014: FETCH get_aggregation_end INTO l_aggregation_end;
1015: CLOSE get_aggregation_end;
1016: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
1017: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1018: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1019: --
1020: -- bug 9910054, consider asg actions with non zero taxable pay or PAYE.
1021: -- 5144343: Get aggregated action within the aggregation period only

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

1014: FETCH get_aggregation_end INTO l_aggregation_end;
1015: CLOSE get_aggregation_end;
1016: hr_utility.trace('After get_aggregation_end, l_aggregation_end='||fnd_date.date_to_displaydate(l_aggregation_end));
1017: l_agg_active_start := pay_gb_eoy_archive.get_agg_active_start(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1018: l_agg_active_end := pay_gb_eoy_archive.get_agg_active_end(X_ASSIGNMENT_ID, X_TAX_REFERENCE, X_ASSIGNMENT_END_DATE);
1019: --
1020: -- bug 9910054, consider asg actions with non zero taxable pay or PAYE.
1021: -- 5144343: Get aggregated action within the aggregation period only
1022: /* open agg_latest_action(X_PERSON_ID, least(X_TRANSFER_DATE, l_aggregation_end),

Line 1545: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1541: CURSOR csr_get_p45_start_end_date(p_payroll_action_id NUMBER) IS
1542: SELECT
1543: start_date,
1544: fnd_date.canonical_to_date
1545: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1546: 'DATE_TO')) end_date
1547: FROM pay_payroll_actions
1548: WHERE payroll_action_id = p_payroll_action_id;
1549:

Line 1557: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1553:
1554: CURSOR csr_get_p45_EDI_start_end_date(p_payroll_action_id NUMBER) IS
1555: SELECT
1556: fnd_date.canonical_to_date
1557: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1558: 'DATE_FROM')) start_date,
1559: fnd_date.canonical_to_date
1560: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1561: 'END_DATE')) end_date

Line 1560: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

1556: fnd_date.canonical_to_date
1557: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1558: 'DATE_FROM')) start_date,
1559: fnd_date.canonical_to_date
1560: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
1561: 'END_DATE')) end_date
1562: FROM pay_payroll_actions
1563: WHERE payroll_action_id = p_payroll_action_id;
1564: -- End of BUG 5671777-11

Line 2209: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2205: l_inc_asg_index NUMBER;
2206: --
2207: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2208: SELECT
2209: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2210: 'PAYROLL_ID')) payroll_id,
2211: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2212: 'TAX_REF'),1,20) tax_ref,
2213: start_date,

Line 2211: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2207: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2208: SELECT
2209: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2210: 'PAYROLL_ID')) payroll_id,
2211: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2212: 'TAX_REF'),1,20) tax_ref,
2213: start_date,
2214: effective_date,
2215: fnd_date.canonical_to_date

Line 2216: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

2212: 'TAX_REF'),1,20) tax_ref,
2213: start_date,
2214: effective_date,
2215: fnd_date.canonical_to_date
2216: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
2217: 'DATE_TO')) end_date,
2218: business_group_id
2219: FROM pay_payroll_actions
2220: WHERE payroll_action_id = p_payroll_action_id;

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

2268: per_assignment_status_types past
2269: WHERE a.assignment_id = a3.assignment_id
2270: AND a3.assignment_status_type_id = past.assignment_status_type_id
2271: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2272: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)
2273: AND a3.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_term_date));
2274:
2275: --
2276: /* Fix performance bug by split cursor into 2 */

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

2269: WHERE a.assignment_id = a3.assignment_id
2270: AND a3.assignment_status_type_id = past.assignment_status_type_id
2271: AND past.per_system_status in ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
2272: AND a3.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_assignment_id, c_tax_ref, c_term_date)
2273: AND a3.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_assignment_id, c_tax_ref, c_term_date));
2274:
2275: --
2276: /* Fix performance bug by split cursor into 2 */
2277: cursor csr_all_assignments is

Line 2945: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2941: AND business_group_id IS NULL;
2942: --
2943: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2944: SELECT
2945: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2946: 'PAYROLL_ID')) payroll_id,
2947: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2948: 'CHAR_ERROR'),
2949: 'Y','TRUE','N','FALSE') check_chars,

Line 2947: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,

2943: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
2944: SELECT
2945: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2946: 'PAYROLL_ID')) payroll_id,
2947: decode(pay_gb_eoy_archive.get_parameter(legislative_parameters,
2948: 'CHAR_ERROR'),
2949: 'Y','TRUE','N','FALSE') check_chars,
2950: effective_date
2951: FROM pay_payroll_actions

Line 2955: SELECT pay_gb_eoy_archive.get_parameter(legislative_parameters,'EDI_VER') edi_ver

2951: FROM pay_payroll_actions
2952: WHERE payroll_action_id = p_payroll_action_id;
2953: --
2954: cursor csr_version_info(p_payroll_action_id NUMBER) IS
2955: SELECT pay_gb_eoy_archive.get_parameter(legislative_parameters,'EDI_VER') edi_ver
2956: FROM pay_payroll_actions
2957: WHERE payroll_action_id = p_payroll_action_id;
2958:
2959: BEGIN

Line 3097: SELECT payroll_id,pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')

3093: --------------------------------------------------------------------------
3094: -- Code to update the payroll_id in the pay_payroll_actions table. -- Bug 8815269
3095: --------------------------------------------------------------------------
3096:
3097: SELECT payroll_id,pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYROLL_ID')
3098: INTO l_ppa_payroll_id,l_payroll_id
3099: FROM pay_payroll_actions
3100: WHERE payroll_action_id = p_payroll_action_id ;
3101:

Line 3197: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str

3193:
3194: --
3195: cursor csr_asg_act_info(p_asgactid NUMBER) IS
3196: SELECT act.assignment_id,
3197: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3198: (act.assignment_action_id,
3199: g_termination_date_eid)) term_date,
3200: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3201: g_tax_ref_transfer_eid) tax_ref_transfer

Line 3200: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,

3196: SELECT act.assignment_id,
3197: fnd_date.canonical_to_date(pay_gb_eoy_archive.get_arch_str
3198: (act.assignment_action_id,
3199: g_termination_date_eid)) term_date,
3200: pay_gb_eoy_archive.get_arch_str(act.assignment_action_id,
3201: g_tax_ref_transfer_eid) tax_ref_transfer
3202: FROM pay_assignment_actions act
3203: WHERE act.assignment_action_id = p_asgactid;
3204: --

Line 4096: pay_gb_eoy_archive.get_parameter(legislative_parameters,

4092: /*P45 A4 2008-09 changes */
4093: /*Cursor to fetch stationary type and differ printing option*/
4094: cursor csr_get_stationary_defer(c_payroll_action_id NUMBER) IS
4095: select
4096: pay_gb_eoy_archive.get_parameter(legislative_parameters,
4097: 'P45') stationary_type,
4098: pay_gb_eoy_archive.get_parameter(legislative_parameters,
4099: 'PDEF') defer_print
4100: from pay_payroll_actions

Line 4098: pay_gb_eoy_archive.get_parameter(legislative_parameters,

4094: cursor csr_get_stationary_defer(c_payroll_action_id NUMBER) IS
4095: select
4096: pay_gb_eoy_archive.get_parameter(legislative_parameters,
4097: 'P45') stationary_type,
4098: pay_gb_eoy_archive.get_parameter(legislative_parameters,
4099: 'PDEF') defer_print
4100: from pay_payroll_actions
4101: where payroll_action_id = c_payroll_action_id;
4102: /*P45 A4 2008-09 changes */

Line 4288: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,

4284: AND business_group_id IS NULL;
4285: --
4286: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
4287: SELECT
4288: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4289: 'PAYROLL_ID')) payroll_id,
4290: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4291: 'TAX_REF'),1,20) tax_ref,
4292: fnd_date.canonical_to_date

Line 4290: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,

4286: cursor csr_parameter_info(p_payroll_action_id NUMBER) IS
4287: SELECT
4288: to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4289: 'PAYROLL_ID')) payroll_id,
4290: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4291: 'TAX_REF'),1,20) tax_ref,
4292: fnd_date.canonical_to_date
4293: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
4294: 'DATE_FROM')) start_date,

Line 4293: (pay_gb_eoy_archive.get_parameter(legislative_parameters,

4289: 'PAYROLL_ID')) payroll_id,
4290: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
4291: 'TAX_REF'),1,20) tax_ref,
4292: fnd_date.canonical_to_date
4293: (pay_gb_eoy_archive.get_parameter(legislative_parameters,
4294: 'DATE_FROM')) start_date,
4295: effective_date end_date,
4296: business_group_id
4297: FROM pay_payroll_actions

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

4858: per_assignment_status_types past
4859: where a.assignment_status_type_id = past.assignment_status_type_id
4860: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4861: and a.assignment_id = c_assignment_id
4862: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)
4863: and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_agg_assignment_id, c_tax_ref, c_effective_date)
4864: ;
4865:
4866: cursor csr_aggr_paye_flag (c_person_id number,

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

4859: where a.assignment_status_type_id = past.assignment_status_type_id
4860: and past.per_system_status IN ('ACTIVE_ASSIGN', 'SUSP_ASSIGN')
4861: and a.assignment_id = c_assignment_id
4862: and a.effective_start_date <= pay_gb_eoy_archive.get_agg_active_end(c_agg_assignment_id, c_tax_ref, c_effective_date)
4863: and a.effective_end_date >= pay_gb_eoy_archive.get_agg_active_start(c_agg_assignment_id, c_tax_ref, c_effective_date)
4864: ;
4865:
4866: cursor csr_aggr_paye_flag (c_person_id number,
4867: c_effective_date date) is