[Home] [Help]
2067: assignment_id . Take it from pay_action_context table. */
2068:
2069: cursor c_get_province(p_asgid number) is
2070: select distinct context_value
2071: from pay_action_contexts pac
2072: where pac.assignment_id = p_asgid;
2073:
2074: /* for testing , since there is no data in pay_action_contexts table */
2075: cursor c_get_test_province is
2070: select distinct context_value
2071: from pay_action_contexts pac
2072: where pac.assignment_id = p_asgid;
2073:
2074: /* for testing , since there is no data in pay_action_contexts table */
2075: cursor c_get_test_province is
2076: select province_abbrev
2077: from pay_ca_provinces_v pac;
2078:
2180: from per_all_assignments_f paf,
2181: pay_assignment_actions paa,
2182: pay_payroll_actions ppa,
2183: pay_action_classifications pac,
2184: pay_action_contexts pac1,
2185: ff_contexts fc
2186: where paf.person_id = p_person_id
2187: and paa.assignment_id = paf.assignment_id
2188: and paa.tax_unit_id = l_tax_unit_id
2217: per_all_assignments_f paf,
2218: per_all_people_f ppf,
2219: pay_payroll_actions ppa,
2220: pay_action_classifications pac,
2221: pay_action_contexts pac1,
2222: ff_contexts fc
2223: where ppf.person_id = cp_person_id
2224: and paf.person_id = ppf.person_id
2225: and paf.assignment_id = paa.assignment_id
2338: end if;
2339:
2340: /* Now, set up the jurisdiction context for the db items that
2341: need the jurisdiction as a context.Here we are archiving all the
2342: jurisdictions we got from pay_action_contexts for all assignment_actions.
2343: So even though a particular assignment_action is for aparticular jurisdiction
2344: the archiver table has data for all the jurisdictions, but values of
2345: irrelevant jurisdictions will be 0 */
2346: