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_CA_EOY_RL2_ARCHIVE dependencies on FF_CONTEXTS

Line 924: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc

920: where hoi.org_information_context = 'Canada Employer Identification'
921: and hoi.org_information2 = l_pre_org_id
922: and hoi.org_information5 = 'T4A/RL2')
923: AND PPY.payroll_id = ASG.payroll_id
924: and exists ( select 'X' from pay_action_contexts pac, ff_contexts fc
925: where pac.assignment_id = asg.assignment_id
926: and pac.context_id = fc.context_id
927: and fc.context_name = 'JURISDICTION_CODE'
928: and pac.context_value = 'QC' )

Line 963: ff_contexts fc

959: AND ppa.effective_date between asg.effective_start_date
960: and asg.effective_end_date
961: AND EXISTS (select 1
962: from pay_action_contexts pac,
963: ff_contexts fc
964: where pac.assignment_id = paa.assignment_id
965: and pac.assignment_action_id = paa.assignment_action_id
966: and pac.context_id = fc.context_id
967: and fc.context_name || '' = 'JURISDICTION_CODE'

Line 1789: l_jursd_context_id ff_contexts.context_id%type;

1785: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
1786: l_step number := 0;
1787: l_county_code varchar2(3);
1788: l_city_code varchar2(4);
1789: l_jursd_context_id ff_contexts.context_id%type;
1790: l_taxunit_context_id ff_contexts.context_id%type;
1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;

Line 1790: l_taxunit_context_id ff_contexts.context_id%type;

1786: l_step number := 0;
1787: l_county_code varchar2(3);
1788: l_city_code varchar2(4);
1789: l_jursd_context_id ff_contexts.context_id%type;
1790: l_taxunit_context_id ff_contexts.context_id%type;
1791: l_seq_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1792: l_context_id_tab pay_ca_eoy_rl2_archive.number_data_type_table;
1793: l_context_val_tab pay_ca_eoy_rl2_archive.char240_data_type_table;
1794: l_chunk number;

Line 2036: ff_contexts fc

2032: per_all_people_f ppf,
2033: pay_payroll_actions ppa,
2034: pay_action_classifications pac,
2035: pay_action_contexts pac1,
2036: ff_contexts fc
2037: where ppf.person_id = cp_person_id
2038: and paf.person_id = ppf.person_id
2039: and paa.assignment_id = paf.assignment_id
2040: and paa.tax_unit_id = cp_tax_unit_id

Line 2162: /* Get the context_id for 'Jurisdiction' from ff_contexts */

2158:
2159:
2160: l_step := 3;
2161:
2162: /* Get the context_id for 'Jurisdiction' from ff_contexts */
2163:
2164: l_step := 5;
2165:
2166: select context_id

Line 2168: from ff_contexts

2164: l_step := 5;
2165:
2166: select context_id
2167: into l_jursd_context_id
2168: from ff_contexts
2169: where context_name = 'JURISDICTION_CODE';
2170:
2171: select context_id
2172: into l_taxunit_context_id

Line 2173: from ff_contexts

2169: where context_name = 'JURISDICTION_CODE';
2170:
2171: select context_id
2172: into l_taxunit_context_id
2173: from ff_contexts
2174: where context_name = 'TAX_UNIT_ID';
2175:
2176: l_step := 6;
2177:

Line 3268: ff_contexts fc

3264: and ppa.payroll_id = ppy.payroll_id
3265: and ppy.business_group_id = '||to_char(l_business_group)||'
3266: and exists (select 1
3267: from pay_action_contexts pac,
3268: ff_contexts fc
3269: where pac.assignment_id = paa.assignment_id
3270: and pac.assignment_action_id = paa.assignment_action_id
3271: and pac.context_id = fc.context_id
3272: and fc.context_name = ''JURISDICTION_CODE''