[Home] [Help]
163: ee_effstart date;
164: -- bug 6655722
165: -- max_effend date;
166: val_date date;
167: asgno per_all_assignments_f.assignment_number%type;
168: link_id number;
169: lookup_type hr_lookups.lookup_type%type;
170: -- Bugfix 2827092
171: --value_set_id pay_input_values_f.value_set_id%type;
213: from pay_element_entries_f pee,
214: pay_element_links_f pel,
215: pay_element_types_f pet,
216: pay_input_values_f piv,
217: per_all_assignments_f asg
218: where asg.assignment_id = p_assignment_id
219: and p_effective_date between
220: asg.effective_start_date and asg.effective_end_date
221: and pel.element_type_id = p_element_type_id
764: pee.effective_start_date
765: into stop_ee_id, link_id, stop_ee_start_date
766: from pay_element_entries_f pee,
767: pay_element_links_f pel,
768: per_all_assignments_f asg
769: where asg.assignment_id = p_assignment_id
770: and p_date_earned between
771: asg.effective_start_date and asg.effective_end_date
772: and pel.element_type_id = p_element_type_id
971: is
972: --
973: cursor dp (p_per_of_serv in number) is
974: select distinct paf.assignment_id
975: from per_all_assignments_f paf
976: where paf.period_of_service_id = p_per_of_serv;
977: --
978: cursor csr_locker (p_asg_id in number,
979: p_eff_date in date)
1026: is
1027: --
1028: cursor dp (p_per_of_serv in number) is
1029: select distinct paf.assignment_id
1030: from per_all_assignments_f paf
1031: where paf.period_of_service_id = p_per_of_serv;
1032: --
1033: cursor csr_locker (p_asg_id in number,
1034: p_eff_date in date)
1079: is
1080: --
1081: cursor dp (p_per_of_serv in number) is
1082: select distinct paf.assignment_id
1083: from per_all_assignments_f paf
1084: where paf.period_of_service_id = p_per_of_serv;
1085: --
1086: cursor csr_locker (p_asg_id in number,
1087: p_eff_date in date)
1287: select '|| case chkno when null then '' else l_hints end ||' act.assignment_id,
1288: act.assignment_action_id
1289: from hr_assignment_sets has,
1290: pay_population_ranges pop,
1291: per_all_assignments_f pay_asg,
1292: pay_payroll_actions pac,
1293: pay_assignment_actions act
1294: where pac.payroll_action_id = :pactid
1295: and act.payroll_action_id = pac.payroll_action_id
1296: and act.source_action_id is null
1297: and pay_asg.assignment_id = act.assignment_id
1298: and ((pac.action_type = ''BEE''
1299: and pay_asg.effective_start_date = (select max(asg2.effective_start_date)
1300: from per_all_assignments_f asg2
1301: where asg2.assignment_id =
1302: pay_asg.assignment_id))
1303: or
1304: (pac.action_type <> ''BEE''
1327: act.assignment_action_id
1328: from pay_payroll_actions pac,
1329: pay_population_ranges pop,
1330: hr_assignment_set_amendments amd,
1331: per_all_assignments_f pay_asg,
1332: pay_assignment_actions act
1333: where pac.payroll_action_id = :pactid
1334: and act.payroll_action_id = pac.payroll_action_id
1335: and act.source_action_id is null
1335: and act.source_action_id is null
1336: and pay_asg.assignment_id = act.assignment_id
1337: and ((pac.action_type = ''BEE''
1338: and pay_asg.effective_start_date = (select max(asg2.effective_start_date)
1339: from per_all_assignments_f asg2
1340: where asg2.assignment_id =
1341: pay_asg.assignment_id))
1342: or
1343: (pac.action_type <> ''BEE''
1404: -- Use information to build sql statements.
1405: if(everyone) then
1406: sqlstr := '
1407: select pay_asg.assignment_id
1408: from per_all_assignments_f pay_asg,
1409: hr_assignment_sets has
1410: where has.assignment_set_id = :v_asg_set
1411: and pay_asg.payroll_id = has.payroll_id
1412: and fnd_date.canonical_to_date(:v_effective_date) between
1415: --
1416: if(include) then
1417: sqlstr := '
1418: select pay_asg.assignment_id
1419: from per_all_assignments_f pay_asg,
1420: hr_assignment_sets has,
1421: hr_assignment_set_amendments amd
1422: where has.assignment_set_id = :asetid
1423: and amd.assignment_set_id = has.assignment_set_id
1430: --
1431: if(exclude) then
1432: sqlstr := '
1433: select pay_asg.assignment_id
1434: from per_all_assignments_f pay_asg,
1435: hr_assignment_sets has
1436: where has.assignment_set_id = :asetid
1437: and pay_asg.payroll_id = has.payroll_id
1438: and fnd_date.canonical_to_date(:v_effective_date) between
1502: --
1503: sqlstr := '
1504: select pay_asg.assignment_id, pay_asg.assignment_number,
1505: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1506: from per_all_assignments_f pay_asg,
1507: hr_assignment_sets has,
1508: PAY_ELEMENT_SET_MEMBERS pesm,
1509: pay_element_types_f petf
1510: where pay_asg.business_group_id = :p_bgid
1536: --
1537: sqlstr := '
1538: select pay_asg.assignment_id, pay_asg.assignment_number,
1539: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1540: from per_all_assignments_f pay_asg,
1541: hr_assignment_sets has,
1542: pay_element_types_f petf
1543: where pay_asg.business_group_id = :p_bgid
1544: and has.assignment_set_id = :pasetid
1558: --
1559: sqlstr := '
1560: select pay_asg.assignment_id, pay_asg.assignment_number,
1561: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1562: from per_all_assignments_f pay_asg,
1563: hr_assignment_sets has,
1564: hr_assignment_set_amendments amd,
1565: PAY_ELEMENT_SET_MEMBERS pesm,
1566: pay_element_types_f petf
1595: --
1596: sqlstr := '
1597: select pay_asg.assignment_id, pay_asg.assignment_number,
1598: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1599: from per_all_assignments_f pay_asg,
1600: hr_assignment_sets has,
1601: hr_assignment_set_amendments amd,
1602: pay_element_types_f petf
1603: where pay_asg.business_group_id = :p_bgid
1620: --
1621: sqlstr := '
1622: select pay_asg.assignment_id, pay_asg.assignment_number,
1623: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1624: from per_all_assignments_f pay_asg,
1625: hr_assignment_sets has,
1626: PAY_ELEMENT_SET_MEMBERS pesm,
1627: pay_element_types_f petf
1628: where pay_asg.business_group_id = :p_bgid
1659: --
1660: sqlstr := '
1661: select pay_asg.assignment_id, pay_asg.assignment_number,
1662: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1663: from per_all_assignments_f pay_asg,
1664: hr_assignment_sets has,
1665: pay_element_types_f petf
1666: where pay_asg.business_group_id = :p_bgid
1667: and has.assignment_set_id = :pasetid
1695: --
1696: sqlstr := '
1697: select pay_asg.assignment_id, pay_asg.assignment_number,
1698: pay_asg.payroll_id, pesm.element_type_id, petf.element_name
1699: from per_all_assignments_f pay_asg,
1700: PAY_ELEMENT_SET_MEMBERS pesm,
1701: pay_element_types_f petf
1702: where pay_asg.business_group_id = :p_bgid
1703: and pay_asg.assignment_type = ''E''
1726: --
1727: sqlstr := '
1728: select pay_asg.assignment_id, pay_asg.assignment_number,
1729: pay_asg.payroll_id,petf.element_type_id, petf.element_name
1730: from per_all_assignments_f pay_asg,
1731: pay_element_types_f petf
1732: where pay_asg.business_group_id = :p_bgid
1733: and pay_asg.assignment_type = ''E''
1734: and fnd_date.canonical_to_date(:p_effective_date)
1779: if(everyone and (not include)) then
1780: sqlstr := '
1781: select pay_asg.assignment_id,
1782: pay_asg.payroll_id
1783: from per_all_assignments_f pay_asg,
1784: hr_assignment_sets has,
1785: per_quickpaint_invocations inv
1786: where inv.qp_invocation_id = :qp_invocation_id
1787: and has.assignment_set_id = inv.invocation_context
1794: if(include) then
1795: sqlstr := '
1796: select pay_asg.assignment_id,
1797: pay_asg.payroll_id
1798: from per_all_assignments_f pay_asg,
1799: hr_assignment_sets has,
1800: hr_assignment_set_amendments amd,
1801: per_quickpaint_invocations inv
1802: where inv.qp_invocation_id = :qp_invocation_id
1921:
1922: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
1923: pbg.legislation_code
1924: into l_legislation
1925: from per_all_assignments_f paf,
1926: per_business_groups_perf pbg
1927: where paf.assignment_id = p_assignment_id
1928: and p_effective_date between paf.effective_start_date
1929: and paf.effective_end_date
1963: pbg.legislation_code,
1964: pbg.business_group_id
1965: into l_legislation,
1966: l_business_group_id
1967: from per_all_assignments_f paf,
1968: per_business_groups_perf pbg
1969: where paf.assignment_id = p_assignment_id
1970: and p_effective_date between paf.effective_start_date
1971: and paf.effective_end_date
2045: p_assignment_id number
2046: ,p_effective_date date
2047: ) is
2048: select to_number(SCL.segment1) tax_unit_id
2049: from per_all_assignments_f ASG
2050: ,hr_soft_coding_keyflex SCL
2051: where ASG.assignment_id = p_assignment_id
2052: and SCL.soft_coding_keyflex_id = ASG.soft_coding_keyflex_id
2053: and p_effective_date between ASG.effective_start_date
2060: p_assignment_id number
2061: ,p_effective_date date
2062: ) is
2063: select establishment_id
2064: from per_all_assignments_f ASG
2065: where ASG.assignment_id = p_assignment_id
2066: and p_effective_date between ASG.effective_start_date
2067: and ASG.effective_end_date;
2068: --
2083:
2084: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2085: pbg.legislation_code
2086: into l_legislation
2087: from per_all_assignments_f paf,
2088: per_business_groups_perf pbg
2089: where paf.assignment_id = p_assignment_id
2090: and p_effective_date between paf.effective_start_date
2091: and paf.effective_end_date
2134: --
2135: select /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
2136: pbg.legislation_code
2137: into l_legislation
2138: from per_all_assignments_f paf,
2139: per_business_groups_perf pbg
2140: where paf.assignment_id = p_assignment_id
2141: and p_effective_date between paf.effective_start_date
2142: and paf.effective_end_date
2905: --
2906: beeasg := '
2907: from pay_payroll_actions pay_pac,
2908: pay_batch_lines pay_btl,
2909: per_all_assignments_f pay_asg
2910: where pay_pac.payroll_action_id = :payroll_action_id
2911: and pay_pac.batch_id = pay_btl.batch_id
2912: and pay_btl.assignment_id = pay_asg.assignment_id
2913: and pay_btl.effective_date between pay_asg.effective_start_date
2918: -- Note, assignments must be effective
2919: -- at both date paid and date earned.
2920: allasg := '
2921: from per_periods_of_service pay_pos,
2922: per_all_assignments_f pay_asg,
2923: per_all_assignments_f pay_as2,
2924: pay_payroll_actions pay_pac
2925: where pay_pac.payroll_action_id = :payroll_action_id
2926: and pay_asg.payroll_id = pay_pac.payroll_id
2919: -- at both date paid and date earned.
2920: allasg := '
2921: from per_periods_of_service pay_pos,
2922: per_all_assignments_f pay_asg,
2923: per_all_assignments_f pay_as2,
2924: pay_payroll_actions pay_pac
2925: where pay_pac.payroll_action_id = :payroll_action_id
2926: and pay_asg.payroll_id = pay_pac.payroll_id
2927: and pay_pac.effective_date between
2934: --
2935: -- Reversal range row select
2936: revallasg := '
2937: from per_periods_of_service pay_pos,
2938: per_all_assignments_f pay_asg,
2939: per_all_assignments_f pay_as2,
2940: pay_payroll_actions pay_pac,
2941: pay_assignment_actions pay_paa2,
2942: pay_payroll_actions pay_pac2
2935: -- Reversal range row select
2936: revallasg := '
2937: from per_periods_of_service pay_pos,
2938: per_all_assignments_f pay_asg,
2939: per_all_assignments_f pay_as2,
2940: pay_payroll_actions pay_pac,
2941: pay_assignment_actions pay_paa2,
2942: pay_payroll_actions pay_pac2
2943: where pay_pac.payroll_action_id = :payroll_action_id
2957: --
2958: -- Purge range row select.
2959: purallasg := '
2960: from per_periods_of_service pay_pos,
2961: per_all_assignments_f pay_asg,
2962: pay_payroll_actions pay_pac
2963: where pay_pac.payroll_action_id = :pactid
2964: and pay_asg.business_group_id + 0 = pay_pac.business_group_id
2965: and pay_asg.payroll_id is not null
2968: --
2969: -- Retropay assignments
2970: allretasg := '
2971: from per_periods_of_service pay_pos,
2972: per_all_assignments_f pay_asg,
2973: pay_payroll_actions pay_pac
2974: where pay_pac.payroll_action_id = :payroll_action_id
2975: and pay_asg.payroll_id = pay_pac.payroll_id
2976: and pay_pac.effective_date between
2979: --
2980: -- RetroCost assignments
2981: allrcsasg := '
2982: from per_periods_of_service pay_pos,
2983: per_all_assignments_f pay_asg,
2984: pay_payroll_actions pay_pac
2985: where pay_pac.payroll_action_id = :pactid
2986: and (pay_asg.payroll_id = pay_pac.payroll_id or pay_pac.payroll_id is null)
2987: and pay_pac.effective_date between
2989: and pay_pos.period_of_service_id = pay_asg.period_of_service_id
2990: and exists (select null
2991: from pay_action_classifications pay_pcl,
2992: pay_assignment_actions pay_act,
2993: per_all_assignments_f pay_asg2,
2994: pay_payroll_actions pay_pac2
2995: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
2996: and pay_pac2.effective_date between
2997: pay_pac.start_date and pay_pac.effective_date
3016: -- limit of overall statement returned ... SO CARE MUST BE TAKEN
3017: -- IN ANY CHANGES BEING MADE.
3018: alladvasg := '
3019: from per_periods_of_service pay_pos,
3020: per_all_assignments_f pay_asg,
3021: pay_payroll_actions pay_pac
3022: where pay_pac.payroll_action_id = :payroll_action_id
3023: and pay_asg.payroll_id + 0 = pay_pac.payroll_id
3024: and pay_pac.effective_date between
3074: -- limit of overall statement returned ... SO CARE MUST BE TAKEN
3075: -- IN ANY CHANGES BEING MADE.
3076: alladeasg := '
3077: from per_periods_of_service pay_pos,
3078: per_all_assignments_f pay_asg,
3079: pay_payroll_actions pay_pac
3080: where pay_pac.payroll_action_id = :pactid
3081: and pay_asg.payroll_id = pay_pac.payroll_id
3082: and pay_pac.effective_date between
3120: -- limit of overall statement returned ... SO CARE MUST BE TAKEN
3121: -- IN ANY CHANGES BEING MADE.
3122: adeincspc := '
3123: from per_periods_of_service pay_pos,
3124: per_all_assignments_f pay_asg,
3125: pay_payroll_actions pay_pac,
3126: hr_assignment_set_amendments pay_inc
3127: where pay_pac.payroll_action_id = :pactid
3128: and pay_asg.payroll_id = pay_pac.payroll_id
3167: --
3168: -- Specific inclusions in range creation assignment action phase
3169: rspcinc := '
3170: from per_periods_of_service pay_pos,
3171: per_all_assignments_f pay_asg,
3172: per_all_assignments_f pay_as2,
3173: hr_assignment_set_amendments pay_inc,
3174: pay_payroll_actions pay_pac
3175: where pay_pac.payroll_action_id = :payroll_action_id
3168: -- Specific inclusions in range creation assignment action phase
3169: rspcinc := '
3170: from per_periods_of_service pay_pos,
3171: per_all_assignments_f pay_asg,
3172: per_all_assignments_f pay_as2,
3173: hr_assignment_set_amendments pay_inc,
3174: pay_payroll_actions pay_pac
3175: where pay_pac.payroll_action_id = :payroll_action_id
3176: and pay_pac.assignment_set_id = pay_inc.assignment_set_id
3189: -- Bug 14740436: Removed Decode decode(pay_pos.period_of_service_id, null, 0, 0)
3190: -- function which is insignificant and causing performance issue.
3191: spcinc := '
3192: from per_periods_of_service pay_pos,
3193: per_all_assignments_f pay_asg,
3194: per_all_assignments_f pay_as2,
3195: hr_assignment_set_amendments pay_inc,
3196: pay_payroll_actions pay_pac
3197: where pay_pac.payroll_action_id = :payroll_action_id
3190: -- function which is insignificant and causing performance issue.
3191: spcinc := '
3192: from per_periods_of_service pay_pos,
3193: per_all_assignments_f pay_asg,
3194: per_all_assignments_f pay_as2,
3195: hr_assignment_set_amendments pay_inc,
3196: pay_payroll_actions pay_pac
3197: where pay_pac.payroll_action_id = :payroll_action_id
3198: and pay_inc.assignment_set_id = pay_pac.assignment_set_id
3208: and pay_as2.period_of_service_id = pay_asg.period_of_service_id';
3209: --
3210: revspcinc := '
3211: from per_periods_of_service pay_pos,
3212: per_all_assignments_f pay_asg,
3213: per_all_assignments_f pay_as2,
3214: hr_assignment_set_amendments pay_inc,
3215: pay_payroll_actions pay_pac,
3216: pay_assignment_actions pay_paa2,
3209: --
3210: revspcinc := '
3211: from per_periods_of_service pay_pos,
3212: per_all_assignments_f pay_asg,
3213: per_all_assignments_f pay_as2,
3214: hr_assignment_set_amendments pay_inc,
3215: pay_payroll_actions pay_pac,
3216: pay_assignment_actions pay_paa2,
3217: pay_payroll_actions pay_pac2
3235: --
3236: -- Purge Specific inclusions.
3237: purspcinc := '
3238: from per_periods_of_service pay_pos,
3239: per_all_assignments_f pay_asg,
3240: hr_assignment_set_amendments pay_inc,
3241: pay_payroll_actions pay_pac
3242: where pay_pac.payroll_action_id = :payroll_action_id
3243: and pay_inc.assignment_set_id = pay_pac.assignment_set_id
3249: --
3250: -- Retropay inclusions
3251: spcretinc := '
3252: from per_periods_of_service pay_pos,
3253: per_all_assignments_f pay_asg,
3254: hr_assignment_set_amendments pay_inc,
3255: pay_payroll_actions pay_pac
3256: where pay_pac.payroll_action_id = :payroll_action_id
3257: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3265: -- RetroCosting inclusions
3266: spcrcsinc := '
3267: from per_periods_of_service pay_pos,
3268: hr_assignment_set_amendments pay_inc,
3269: per_all_assignments_f pay_asg,
3270: per_all_assignments_f pay_as2,
3271: pay_payroll_actions pay_pac
3272: where pay_pac.payroll_action_id = :pactid
3273: and (pay_asg.payroll_id = pay_pac.payroll_id or pay_pac.payroll_id is null)
3266: spcrcsinc := '
3267: from per_periods_of_service pay_pos,
3268: hr_assignment_set_amendments pay_inc,
3269: per_all_assignments_f pay_asg,
3270: per_all_assignments_f pay_as2,
3271: pay_payroll_actions pay_pac
3272: where pay_pac.payroll_action_id = :pactid
3273: and (pay_asg.payroll_id = pay_pac.payroll_id or pay_pac.payroll_id is null)
3274: and pay_pac.effective_date between
3280: and pay_as2.rowid = pay_asg.rowid
3281: and exists (select null
3282: from pay_action_classifications pay_pcl,
3283: pay_assignment_actions pay_act,
3284: per_all_assignments_f pay_asg2,
3285: pay_payroll_actions pay_pac2
3286: where pay_pac2.consolidation_set_id +0 = pay_pac.consolidation_set_id
3287: and pay_pac2.effective_date between
3288: pay_pac.start_date and pay_pac.effective_date
3334: from pay_payroll_actions pay_pa1,
3335: per_time_periods pay_ptp,
3336: pay_payroll_actions pay_pa2,
3337: pay_assignment_actions pay_act,
3338: per_all_assignments_f pay_asg,
3339: per_periods_of_service pay_pos
3340: where pay_pa1.payroll_action_id = :payroll_action_id
3341: and pay_ptp.payroll_id = pay_pa1.payroll_id
3342: and pay_pa1.start_date between
3359: pay_all_payrolls_f pay_pay,
3360: per_time_periods pay_ptp,
3361: pay_payroll_actions pay_pa2,
3362: pay_assignment_actions pay_act,
3363: per_all_assignments_f pay_asg,
3364: per_periods_of_service pay_pos
3365: where pay_pa1.payroll_action_id = :payroll_action_id
3366: and pay_pay.consolidation_set_id = pay_pa1.consolidation_set_id
3367: and pay_pa1.effective_date between
3383: resact := '
3384: from pay_payroll_actions pay_pa1,
3385: pay_payroll_actions pay_pa2,
3386: pay_assignment_actions pay_act,
3387: per_all_assignments_f pay_asg,
3388: per_periods_of_service pay_pos
3389: where pay_pa1.payroll_action_id = :payroll_action_id
3390: and pay_pa2.consolidation_set_id = pay_pa1.consolidation_set_id
3391: and pay_pa2.payroll_id = pay_pa1.payroll_id
3402: nonact := '
3403: from pay_payroll_actions pay_pa1,
3404: pay_payroll_actions pay_pa2,
3405: pay_assignment_actions pay_act,
3406: per_all_assignments_f pay_asg,
3407: per_periods_of_service pay_pos
3408: where pay_pa1.payroll_action_id = :payroll_action_id
3409: and pay_pa2.consolidation_set_id = pay_pa1.consolidation_set_id
3410: and pay_pa2.effective_date between
3420: pruresact := '
3421: from pay_payroll_actions pay_pa1,
3422: pay_payroll_actions pay_pa2,
3423: pay_assignment_actions pay_act,
3424: per_all_assignments_f pay_asg,
3425: per_periods_of_service pay_pos
3426: where pay_pa1.payroll_action_id = :payroll_action_id
3427: and pay_pa2.consolidation_set_id = pay_pa1.consolidation_set_id
3428: and pay_pa2.payroll_id = pay_pa1.payroll_id
3439: prunonact := '
3440: from pay_payroll_actions pay_pa1,
3441: pay_payroll_actions pay_pa2,
3442: pay_assignment_actions pay_act,
3443: per_all_assignments_f pay_asg,
3444: per_periods_of_service pay_pos
3445: where pay_pa1.payroll_action_id = :payroll_action_id
3446: and pay_pa2.consolidation_set_id = pay_pa1.consolidation_set_id
3447: and pay_pa2.effective_date between
3613: --
3614: -- Retropay by Element assignments with retro definition
3615: retdefasg := '
3616: from pay_payroll_actions pay_pac,
3617: per_all_assignments_f pay_asg,
3618: pay_retro_assignments pay_ret_asg,
3619: per_periods_of_service pay_pos
3620: where pay_pac.payroll_action_id = :payroll_action_id
3621: and pay_asg.payroll_id = pay_pac.payroll_id
3630: --
3631: -- Bug 1308309, Quick-Retropay, condition to pick just one assignment
3632: qretdefasg := '
3633: from pay_payroll_actions pay_pac,
3634: per_all_assignments_f pay_asg,
3635: pay_retro_assignments pay_ret_asg,
3636: per_periods_of_service pay_pos
3637: where pay_pac.payroll_action_id = :payroll_action_id
3638: and pay_asg.assignment_id = :assignment_id
3653: where pay_pac.payroll_action_id = :payroll_action_id
3654: and pay_pos.source_type = ''PPF''
3655: and exists (select ''''
3656: from pay_retro_assignments pay_ret_asg,
3657: per_all_assignments_f pay_asg2,
3658: pay_object_groups pay_pog_asg2
3659: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3660: and pay_pog_asg2.source_type = ''PAF''
3661: and pay_asg2.assignment_id = pay_pog_asg2.source_id
3675: where pay_pac.payroll_action_id = :payroll_action_id
3676: and pay_pos.source_type = ''PPF''
3677: and exists (select ''''
3678: from pay_retro_assignments pay_ret_asg,
3679: per_all_assignments_f pay_asg2,
3680: pay_object_groups pay_pog_asg2
3681: where pay_pog_asg2.parent_object_group_id = pay_pos.object_group_id
3682: and pay_pog_asg2.source_type = ''PAF''
3683: and pay_asg2.assignment_id = pay_pog_asg2.source_id