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_JP_SPR_EFILE_PKG dependencies on PAY_JP_WIC_PKG

Line 379: pay_jp_wic_pkg.spr_term_valid(

375: pjwa.person_id pjwa_person_id,
376: pjwa.itax_organization_id,
377: pjwa.actual_termination_date,
378: to_number(decode(to_char(pjwa.actual_termination_date,''YYYY/MM/DD''),null,0,
379: pay_jp_wic_pkg.spr_term_valid(
380: pjwa.assignment_action_id,
381: pjwa.assignment_id,
382: pjwa.action_sequence,
383: pjwa.effective_date,

Line 1792: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then

1788: hr_jp_ast_utility_pkg.get_assignment_set_info(g_assignment_set_id,g_ass_set_formula_id,g_ass_set_amendment_type);
1789: --
1790: end if;
1791: --
1792: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
1793: --
1794: pay_jp_wic_pkg.set_valid_term_taxable_amt(c_valid_term_taxable_amt);
1795: --
1796: end if;

Line 1794: pay_jp_wic_pkg.set_valid_term_taxable_amt(c_valid_term_taxable_amt);

1790: end if;
1791: --
1792: if pay_jp_wic_pkg.g_valid_term_taxable_amt is null then
1793: --
1794: pay_jp_wic_pkg.set_valid_term_taxable_amt(c_valid_term_taxable_amt);
1795: --
1796: end if;
1797: --
1798: if pay_jp_report_pkg.g_char_set is null then

Line 1840: hr_utility.trace('pay_jp_wic_pkg.g_valid_term_taxable_amt : '||to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));

1836: --hr_utility.trace('process_assignments_flag : '||g_process_assignments_flag);
1837: hr_utility.trace('g_remove_act : '||g_remove_act);
1838: hr_utility.trace('g_ass_set_formula_id : '||to_char(g_ass_set_formula_id));
1839: hr_utility.trace('g_ass_set_amendment_type : '||g_ass_set_amendment_type);
1840: hr_utility.trace('pay_jp_wic_pkg.g_valid_term_taxable_amt : '||to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
1841: hr_utility.trace('pay_jp_report_pkg.g_char_set : '||pay_jp_report_pkg.g_char_set);
1842: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_prefix : '||pay_jp_spr_efile_pkg.g_file_prefix);
1843: hr_utility.trace('pay_jp_spr_efile_pkg.g_file_extension : '||pay_jp_spr_efile_pkg.g_file_extension);
1844: end if;

Line 2084: l_select_clause := replace(l_select_clause,'i_valid_term_taxable_amt',to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));

2080: --
2081: --
2082: -- set variable parameter
2083: --
2084: l_select_clause := replace(l_select_clause,'i_valid_term_taxable_amt',to_char(pay_jp_wic_pkg.g_valid_term_taxable_amt));
2085: --
2086: l_from_clause := replace(l_from_clause,'i_business_group_id',to_char(g_business_group_id));
2087: l_from_clause := replace(l_from_clause,'i_effective_soy',fnd_date.date_to_canonical(g_effective_soy));
2088: l_from_clause := replace(l_from_clause,'i_effective_eoy',fnd_date.date_to_canonical(g_effective_eoy));

Line 2369: l_certificate_info pay_jp_wic_pkg.t_certificate_info;

2365: l_file_over_start number;
2366: --
2367: l_data_tbl t_data_tbl;
2368: --
2369: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
2370: l_prev_job_info pay_jp_wic_pkg.t_prev_job_info;
2371: l_housing_info pay_jp_wic_pkg.t_housing_info;
2372: l_submission_required_flag varchar2(1);
2373: --

Line 2370: l_prev_job_info pay_jp_wic_pkg.t_prev_job_info;

2366: --
2367: l_data_tbl t_data_tbl;
2368: --
2369: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
2370: l_prev_job_info pay_jp_wic_pkg.t_prev_job_info;
2371: l_housing_info pay_jp_wic_pkg.t_housing_info;
2372: l_submission_required_flag varchar2(1);
2373: --
2374: l_district_code per_addresses.town_or_city%type;

Line 2371: l_housing_info pay_jp_wic_pkg.t_housing_info;

2367: l_data_tbl t_data_tbl;
2368: --
2369: l_certificate_info pay_jp_wic_pkg.t_certificate_info;
2370: l_prev_job_info pay_jp_wic_pkg.t_prev_job_info;
2371: l_housing_info pay_jp_wic_pkg.t_housing_info;
2372: l_submission_required_flag varchar2(1);
2373: --
2374: l_district_code per_addresses.town_or_city%type;
2375: l_district_code_chg boolean;

Line 2614: pay_jp_wic_pkg.get_certificate_info(

2610: --l_certificate_info.delete;
2611: --l_prev_job_info.delete;
2612: l_submission_required_flag := null;
2613: --
2614: pay_jp_wic_pkg.get_certificate_info(
2615: p_assignment_action_id => l_data_tbl(i).assignment_action_id,
2616: p_assignment_id => l_data_tbl(i).assignment_id,
2617: p_action_sequence => l_data_tbl(i).action_sequence,
2618: p_business_group_id => g_business_group_id,

Line 2904: and l_data_tbl(i).taxable_income <= pay_jp_wic_pkg.g_valid_term_taxable_amt then

2900: if g_valid_term_flag is null
2901: or g_valid_term_flag <> 'Y' then
2902: --
2903: if l_data_tbl(i).actual_termination_date is not null
2904: and l_data_tbl(i).taxable_income <= pay_jp_wic_pkg.g_valid_term_taxable_amt then
2905: --
2906: g_body_tbl(g_assact_tbl(i)).spr_term_valid := 1;
2907: --
2908: end if;