[Home] [Help]
2308: assignment_id . Take it from pay_action_context table. */
2309:
2310: cursor c_get_province(p_asgid number) is
2311: select distinct context_value
2312: from pay_action_contexts pac
2313: where pac.assignment_id = p_asgid;
2314:
2315: /* for testing , since there is no data in pay_action_contexts table */
2316: cursor c_get_test_province is
2311: select distinct context_value
2312: from pay_action_contexts pac
2313: where pac.assignment_id = p_asgid;
2314:
2315: /* for testing , since there is no data in pay_action_contexts table */
2316: cursor c_get_test_province is
2317: select province_abbrev
2318: from pay_ca_provinces_v pac;
2319:
2469: from per_all_assignments_f paf,
2470: pay_assignment_actions paa,
2471: pay_payroll_actions ppa,
2472: pay_action_classifications pac,
2473: pay_action_contexts pac1,
2474: ff_contexts fc
2475: where paf.person_id = p_person_id
2476: and paa.assignment_id = paf.assignment_id
2477: and paa.tax_unit_id = l_tax_unit_id
2506: per_all_assignments_f paf,
2507: per_all_people_f ppf,
2508: pay_payroll_actions ppa,
2509: pay_action_classifications pac,
2510: pay_action_contexts pac1,
2511: ff_contexts fc
2512: where ppf.person_id = cp_person_id
2513: and paf.person_id = ppf.person_id
2514: and paf.assignment_id = paa.assignment_id
2644: end if;
2645:
2646: /* Now, set up the jurisdiction context for the db items that
2647: need the jurisdiction as a context.Here we are archiving all the
2648: jurisdictions we got from pay_action_contexts for all assignment_actions.
2649: So even though a particular assignment_action is for aparticular jurisdiction
2650: the archiver table has data for all the jurisdictions, but values of
2651: irrelevant jurisdictions will be 0 */
2652: