[Home] [Help]
1757: and hoi.organization_id = nvl(g_itax_organization_id,hoi.organization_id)
1758: and hou.organization_id = hoi.organization_id
1759: and hou.business_group_id + 0 = g_business_group_id
1760: and hou.date_from <= g_effective_eoy
1761: and nvl(hou.date_to,hr_api.g_eot) >= g_effective_soy
1762: and not exists(
1763: select null
1764: from pay_payroll_actions ppa,
1765: pay_jp_itax_pact_v2 pjip
7634: per_addresses padr,
7635: per_addresses padc
7636: where pjb.job_id (+) = v.job_id
7637: and v.effective_date
7638: between pjb.date_from (+) and nvl(pjb.date_to(+), hr_api.g_eot)
7639: and hou.organization_id (+) = v.organization_id
7640: and v.effective_date
7641: between hou.date_from (+) and nvl(hou.date_to(+), hr_api.g_eot)
7642: and hlc.location_id (+) = v.location_id
7637: and v.effective_date
7638: between pjb.date_from (+) and nvl(pjb.date_to(+), hr_api.g_eot)
7639: and hou.organization_id (+) = v.organization_id
7640: and v.effective_date
7641: between hou.date_from (+) and nvl(hou.date_to(+), hr_api.g_eot)
7642: and hlc.location_id (+) = v.location_id
7643: and padr.person_id (+) = v.person_id
7644: and padr.address_type (+) = 'JP_R'
7645: and nvl(v.termination_date, v.effective_date)
7642: and hlc.location_id (+) = v.location_id
7643: and padr.person_id (+) = v.person_id
7644: and padr.address_type (+) = 'JP_R'
7645: and nvl(v.termination_date, v.effective_date)
7646: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
7647: and padc.person_id (+) = v.person_id
7648: and padc.address_type (+) = 'JP_C'
7649: and nvl(v.termination_date, v.effective_date)
7650: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
7646: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
7647: and padc.person_id (+) = v.person_id
7648: and padc.address_type (+) = 'JP_C'
7649: and nvl(v.termination_date, v.effective_date)
7650: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
7651: order by
7652: v.assignment_id,
7653: v.action_sequence;
7654: -- balance adjustment is not sequenced process but no comparison key so used as fuzzy sequence
8147: per_addresses padr,
8148: per_addresses padc
8149: where pjb.job_id (+) = v.job_id
8150: and v.effective_date
8151: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)
8152: and hou.organization_id (+) = v.organization_id
8153: and v.effective_date
8154: between hou.date_from (+) and nvl(hou.date_to (+), hr_api.g_eot)
8155: and hlc.location_id (+) = v.location_id
8150: and v.effective_date
8151: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)
8152: and hou.organization_id (+) = v.organization_id
8153: and v.effective_date
8154: between hou.date_from (+) and nvl(hou.date_to (+), hr_api.g_eot)
8155: and hlc.location_id (+) = v.location_id
8156: and padr.person_id (+) = v.person_id
8157: and padr.address_type (+) = 'JP_R'
8158: and nvl(v.termination_date, v.effective_date)
8155: and hlc.location_id (+) = v.location_id
8156: and padr.person_id (+) = v.person_id
8157: and padr.address_type (+) = 'JP_R'
8158: and nvl(v.termination_date, v.effective_date)
8159: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
8160: and padc.person_id (+) = v.person_id
8161: and padc.address_type (+) = 'JP_C'
8162: and nvl(v.termination_date, v.effective_date)
8163: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
8159: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
8160: and padc.person_id (+) = v.person_id
8161: and padc.address_type (+) = 'JP_C'
8162: and nvl(v.termination_date, v.effective_date)
8163: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
8164: order by
8165: v.assignment_id,
8166: v.action_sequence;
8167: -- balance adjustment is not sequenced process but no comparison key so used as fuzzy sequence
8244: hr_locations_all_vl hlc
8245: where padr.person_id (+) = v.person_id
8246: and padr.address_type (+) = 'JP_R'
8247: and nvl(v.actual_termination_date, p_effective_date)
8248: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
8249: and padc.person_id (+) = v.person_id
8250: and padc.address_type (+) = 'JP_C'
8251: and nvl(v.actual_termination_date, p_effective_date)
8252: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
8248: between padr.date_from (+) and nvl(padr.date_to(+), hr_api.g_eot)
8249: and padc.person_id (+) = v.person_id
8250: and padc.address_type (+) = 'JP_C'
8251: and nvl(v.actual_termination_date, p_effective_date)
8252: between padc.date_from (+) and nvl(padc.date_to(+), hr_api.g_eot)
8253: and ppy.payroll_id = v.payroll_id
8254: and p_effective_date
8255: between ppy.effective_start_date and ppy.effective_end_date
8256: and pjb.job_id (+) = v.job_id
8254: and p_effective_date
8255: between ppy.effective_start_date and ppy.effective_end_date
8256: and pjb.job_id (+) = v.job_id
8257: and p_effective_date
8258: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)
8259: and hou.organization_id (+) = v.organization_id
8260: and p_effective_date
8261: between hou.date_from (+) and nvl(hou.date_to (+), hr_api.g_eot)
8262: and hlc.location_id (+) = v.location_id;
8257: and p_effective_date
8258: between pjb.date_from (+) and nvl(pjb.date_to (+), hr_api.g_eot)
8259: and hou.organization_id (+) = v.organization_id
8260: and p_effective_date
8261: between hou.date_from (+) and nvl(hou.date_to (+), hr_api.g_eot)
8262: and hlc.location_id (+) = v.location_id;
8263: --
8264: cursor csr_ass_bon(
8265: p_arch_assignment_action_id_o in number)