[Home] [Help]
150: EL.location_id,
151: EL.pay_basis_id,
152: EL.employment_category,
153: EL.people_group_id
154: from pay_element_links_f EL
155: where EL.element_link_id = p_element_link_id
156: order by EL.effective_start_date;
157: --
158: -- Fetches all assignment rows for a given assignment that match specific
1660: cursor csr_ele_info is
1661: select EL.element_type_id element_type_id,
1662: 'Y' salary_element
1663: from pay_element_entries_f EE,
1664: pay_element_links_f EL
1665: where EE.element_entry_id = p_element_entry_id
1666: and EL.element_link_id = EE.element_link_id
1667: and nvl(p_old_date,p_effective_start_date) between
1668: EE.effective_start_date and EE.effective_end_date
1676: UNION ALL
1677: select EL.element_type_id element_type_id,
1678: 'N' salary_element
1679: from pay_element_entries_f EE,
1680: pay_element_links_f EL
1681: where EE.element_entry_id = p_element_entry_id
1682: and EL.element_link_id = EE.element_link_id
1683: and nvl(p_old_date,p_effective_start_date) between
1684: EE.effective_start_date and EE.effective_end_date
1997: -- with datetrack joins here.
1998: begin
1999: select nvl(pec.non_payments_flag, 'N')
2000: into l_non_payments_flag
2001: from pay_element_links_f pel,
2002: pay_element_types_f pet,
2003: pay_element_classifications pec
2004: where pel.element_link_id = p_element_link_id
2005: and pet.element_type_id = pel.element_type_id
2147: open p_eligible_links_cv for
2148: select el.element_link_id,
2149: min(el.effective_start_date) effective_start_date,
2150: max(el.effective_end_date) effective_end_date
2151: from pay_element_links_f el
2152: where el.element_type_id = p_element_type_id
2153: and el.standard_link_flag = 'N'
2154: and el.business_group_id = p_business_group_id
2155: --
2394: from sys.dual
2395: where exists
2396: (select null
2397: from pay_element_entries_f ee
2398: ,pay_element_links_f el
2399: ,pay_element_types_f et
2400: where ee.assignment_id = p_assignment_id
2401: and ee.element_entry_id = p_element_entry_id
2402: and ee.entry_type = 'E'
2630: el.standard_link_flag,
2631: el.element_type_id
2632: from
2633: pay_element_entries_f ee,
2634: pay_element_links_f el,
2635: pay_element_types_f et
2636: where ee.assignment_id = p_assignment_id
2637: and ee.effective_start_date <= p_validation_end_date
2638: and ee.effective_end_date >= p_validation_start_date
3549: and ((ee.entry_type <> 'E')
3550: or (ee.entry_type = 'E' and
3551: exists
3552: (select null
3553: from pay_element_links_f el,
3554: pay_element_types_f et
3555: where el.element_link_id = ee.element_link_id
3556: and el.element_type_id = et.element_type_id
3557: and et.processing_type = 'N')))
3557: and et.processing_type = 'N')))
3558: and not exists
3559: (select null
3560: from per_all_assignments_f asg,
3561: pay_element_links_f el
3562: where el.element_link_id = ee.element_link_id
3563: and asg.assignment_id = ee.assignment_id
3564: and asg.assignment_type = 'E'
3565: and asg.effective_start_date <= ee.effective_end_date
3895: (
3896: p_element_link_id number
3897: ) is
3898: select et.multiple_entries_allowed_flag
3899: from pay_element_links_f el,
3900: pay_element_types_f et
3901: where el.element_link_id = p_element_link_id
3902: and et.element_type_id = el.element_type_id;
3903: --
4032: --
4033: and not exists
4034: (select null
4035: from per_all_assignments_f asg,
4036: pay_element_links_f el
4037: where asg.assignment_id = ee.assignment_id
4038: and el.element_link_id = ee.element_link_id
4039: and asg.assignment_type = 'E'
4040: and asg.effective_start_date <= ee.effective_end_date
4381: and ((ee.entry_type <> 'E') or
4382: (ee.entry_type = 'E' and
4383: exists
4384: (select null
4385: from pay_element_links_f el,
4386: pay_element_types_f et
4387: where el.element_link_id = ee.element_link_id
4388: and et.element_type_id = el.element_type_id
4389: and et.processing_type = 'N')));
4649: b_effective_date in date,
4650: b_element_link_id in number) is
4651: SELECT dfc.descriptive_flex_context_code
4652: FROM PER_BUSINESS_GROUPS_PERF bg,
4653: PAY_ELEMENT_LINKS_F el,
4654: PAY_ELEMENT_TYPES_F et,
4655: PAY_ELEMENT_CLASSIFICATIONS ec,
4656: FND_DESCR_FLEX_CONTEXTS dfc
4657: WHERE bg.business_group_id =
4866: --
4867: cursor csr_standard_link is
4868: --
4869: select standard_link_flag
4870: from pay_element_links_f
4871: where element_link_id = p_element_link_id
4872: and p_effective_date between effective_start_date
4873: and effective_end_date;
4874: --
5615: where ee.assignment_id = p_assignment_id
5616: and ee.entry_type = 'E'
5617: and exists
5618: (select null
5619: from pay_element_links_f el,
5620: pay_element_types_f et
5621: where el.element_link_id = ee.element_link_id
5622: and el.standard_link_flag = 'Y'
5623: and et.element_type_id = el.element_type_id
5945: and ee.entry_type = 'E'
5946: and nvl(ee.updating_action_type,'null') <> 'S' -- Bugfix 2249308
5947: and exists
5948: (select null
5949: from pay_element_links_f el,
5950: pay_element_types_f et
5951: where el.element_link_id = ee.element_link_id
5952: and el.element_type_id = et.element_type_id
5953: and et.processing_type = 'R')
5956: 'A',nvl(p_actual_term_date,p_sot),
5957: 'L',nvl(p_last_standard_date,p_sot),
5958: 'F',nvl(p_final_process_date,p_sot),
5959: p_sot)
5960: from pay_element_links_f el,
5961: pay_element_types_f et
5962: where el.element_link_id = ee.element_link_id
5963: and et.element_type_id = el.element_type_id
5964: and ee.effective_start_date between el.effective_start_date
6288: el.employment_category,
6289: el.people_group_id,
6290: el.element_type_id,
6291: el.standard_link_flag
6292: from pay_element_links_f el
6293: where el.business_group_id = p_business_group_id
6294: and ((el.standard_link_flag = 'Y' and
6295: exists
6296: (select null
6293: where el.business_group_id = p_business_group_id
6294: and ((el.standard_link_flag = 'Y' and
6295: exists
6296: (select null
6297: from pay_element_links_f el2
6298: where el2.element_link_id = el.element_link_id
6299: and el.effective_start_date <= p_validation_end_date
6300: and el.effective_end_date >= p_validation_start_date))
6301: or (el.standard_link_flag = 'N' and
6318: -- start of change 115.16 --
6319: -- Ensure this non-standard link has not been changed from/to a standard link
6320: and NOT EXISTS
6321: (SELECT null
6322: FROM PAY_ELEMENT_LINKS_F el_sub
6323: WHERE el_sub.element_link_id = el.element_link_id
6324: and el_sub.standard_link_flag = 'Y'
6325: )
6326: -- end of change 115.16 --
6442: p_pay_basis_id is null and
6443: NOT EXISTS
6444: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6445: pb.pay_basis_id
6446: FROM PAY_ELEMENT_LINKS_F el,
6447: PAY_INPUT_VALUES_F iv,
6448: PER_PAY_BASES pb
6449: WHERE el.element_link_id = p_element_link_id
6450: and el.effective_start_date <= asg.effective_start_date
6467: EXISTS
6468: (SELECT pb.pay_basis_id
6469: FROM PER_PAY_BASES pb,
6470: PAY_INPUT_VALUES_F iv,
6471: PAY_ELEMENT_LINKS_F el
6472: WHERE el.element_link_id = p_element_link_id
6473: and el.effective_start_date <= asg.effective_start_date
6474: and el.effective_end_date >= asg.effective_start_date
6475: and iv.element_type_id =
6486: asg.pay_basis_id is null and
6487: EXISTS
6488: (SELECT /*+ ORDERED INDEX(pb PER_PAY_BASES_N1)*/
6489: pb.pay_basis_id
6490: FROM PAY_ELEMENT_LINKS_F el,
6491: PAY_INPUT_VALUES_F iv,
6492: PER_PAY_BASES pb
6493: WHERE el.element_link_id = p_element_link_id
6494: and el.effective_start_date <= asg.effective_start_date
7324: pel.pay_basis_id,
7325: pel.link_to_all_payrolls_flag,
7326: pel.standard_link_flag
7327: from pay_element_entries_f pee,
7328: pay_element_links_f pel
7329: where pee.assignment_id = p_assignment_id
7330: and pel.element_link_id = pee.element_link_id;
7331:
7332: begin