[Home] [Help]
983: where exists (
984: select /*+ index(AC2 PAY_ASSIGNMENT_ACTIONS_N51) */ null
985: from pay_action_classifications acl,
986: pay_assignment_actions ac2,
987: pay_payroll_actions pa2
988: where ac2.assignment_id = p_asg_id
989: and pa2.payroll_action_id = ac2.payroll_action_id
990: and acl.classification_name = 'SEQUENCED'
991: and pa2.action_type = acl.action_type
1038: where exists (
1039: select null
1040: from pay_action_classifications acl,
1041: pay_assignment_actions ac2,
1042: pay_payroll_actions pa2
1043: where ac2.assignment_id = p_asg_id
1044: and pa2.payroll_action_id = ac2.payroll_action_id
1045: and acl.classification_name = 'SEQUENCED'
1046: and pa2.action_type = acl.action_type
1091: where exists (
1092: select null
1093: from pay_action_classifications acl,
1094: pay_assignment_actions ac2,
1095: pay_payroll_actions pa2
1096: where ac2.assignment_id = p_asg_id
1097: and pa2.payroll_action_id = ac2.payroll_action_id
1098: and acl.classification_name = 'SEQUENCED'
1099: and pa2.action_type = acl.action_type
1143: where exists (
1144: select null
1145: from pay_action_classifications acl,
1146: pay_assignment_actions ac2,
1147: pay_payroll_actions pa2
1148: where ac2.assignment_id = p_asg_id
1149: and pa2.payroll_action_id = ac2.payroll_action_id
1150: and acl.classification_name = 'SEQUENCED'
1151: and pa2.action_type = acl.action_type
1161: where exists (
1162: select null
1163: from pay_action_classifications acl,
1164: pay_assignment_actions ac2,
1165: pay_payroll_actions pa2
1166: where ac2.assignment_id = p_asg_id
1167: and pa2.payroll_action_id = ac2.payroll_action_id
1168: and acl.classification_name = 'SEQUENCED'
1169: and pa2.action_type = acl.action_type
1177: where exists (
1178: select null
1179: from pay_action_classifications acl,
1180: pay_assignment_actions ac2,
1181: pay_payroll_actions pa2
1182: where ac2.assignment_id = p_asg_id
1183: and pa2.payroll_action_id = ac2.payroll_action_id
1184: and acl.classification_name = 'SEQUENCED'
1185: and pa2.action_type = acl.action_type
1272: if(everyone) then
1273: /*Bug 12320011 Used profile value to add hint or not */
1274: if l_prof_value is null or l_prof_value = 'Y' then
1275: l_hints := '/*+ use_nl(pac pop has pay_asg act)
1276: index(pac PAY_PAYROLL_ACTIONS_PK)
1277: rowid(pop)
1278: index(has HR_ASSIGNMENT_SETS_PK)
1279: index(pay_asg PER_ASSIGNMENTS_F_N12)
1280: index(act PAY_ASSIGNMENT_ACTIONS_N51) */ ';
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
1312: if(include) then
1313: /*Bug 12320011 Used profile value to add hint or not */
1314: if l_prof_value is null or l_prof_value = 'Y' then
1315: l_hints := '/*+ use_nl(pac pop amd act pay_asg)
1316: index(pac PAY_PAYROLL_ACTIONS_PK)
1317: rowid(pop)
1318: index(amd HR_ASSIGNMENT_SET_AMENDMEN_FK2)
1319: index(act PAY_ASSIGNMENT_ACTIONS_N51)
1320: index(pay_asg PER_ASSIGNMENTS_F_PK) */ ';
1324:
1325: sqlstr := '
1326: select '|| case chkno when null then '' else l_hints end ||' act.assignment_id,
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
1851:
1852: select range_code
1853: into range_proc
1854: from pay_report_format_mappings_f prfm,
1855: pay_payroll_actions ppa
1856: where ppa.payroll_action_id = pactid
1857: and ppa.report_type = prfm.report_type
1858: and ppa.report_qualifier = prfm.report_qualifier
1859: and ppa.report_category = prfm.report_category
2572: -- Processed - confirming its NOT formula-based.
2573: --
2574: select pac.assignment_set_id
2575: into l_asg_set_id
2576: from pay_payroll_actions pac,
2577: hr_assignment_sets has
2578: where pac.payroll_action_id = pactid
2579: and has.assignment_set_id = pac.assignment_set_id
2580: and has.formula_id is null;
2903: ''U'',
2904: null';
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
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
2928: pay_asg.effective_start_date and pay_asg.effective_end_date
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
2944: and pay_asg.payroll_id = pay_pac.payroll_id
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
2944: and pay_asg.payroll_id = pay_pac.payroll_id
2945: and pay_pac.effective_date between
2946: pay_asg.effective_start_date and pay_asg.effective_end_date
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
2966: and pay_asg.effective_start_date <= pay_pac.effective_date
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
2977: pay_asg.effective_start_date and pay_asg.effective_end_date
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
2988: pay_asg.effective_start_date and pay_asg.effective_end_date
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
2998: and pay_act.payroll_action_id = pay_pac2.payroll_action_id
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
3025: pay_asg.effective_start_date and pay_asg.effective_end_date
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
3083: pay_asg.effective_start_date and pay_asg.effective_end_date
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
3129: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
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
3177: and pay_asg.assignment_id = pay_inc.assignment_id
3178: and pay_asg.payroll_id = pay_pac.payroll_id
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
3199: and pay_inc.assignment_id = pay_asg.assignment_id
3200: and pay_asg.payroll_id = pay_pac.payroll_id
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
3218: where pay_pac.payroll_action_id = :payroll_action_id
3219: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
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
3218: where pay_pac.payroll_action_id = :payroll_action_id
3219: and pay_inc.assignment_set_id = pay_pac.assignment_set_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3220: and pay_inc.assignment_id = pay_asg.assignment_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3221: and pay_asg.payroll_id = pay_pac.payroll_id
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
3244: and pay_inc.assignment_id = pay_asg.assignment_id
3245: and pay_asg.payroll_id is not null
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)
3258: and pay_inc.assignment_id = pay_asg.assignment_id + decode(pay_pos.period_of_service_id, null, 0, 0)
3259: and pay_asg.payroll_id + 0 = pay_pac.payroll_id
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
3275: pay_asg.effective_start_date and pay_asg.effective_end_date
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
3289: and pay_act.payroll_action_id = pay_pac2.payroll_action_id
3330: -- Estimate Costing Restricted payroll action range row
3331: -- where clause. i.e. restricted by payroll_id.
3332: -- nb have to join to per_time_periods at pa.start_date
3333: ecsresact := '
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,
3332: -- nb have to join to per_time_periods at pa.start_date
3333: ecsresact := '
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
3354: -- Estimate Costing Unrestricted payroll action range row
3355: -- where clause. i.e. not restricted by payroll_id.
3356: -- nb have to join to per_time_periods at pa.start_date
3357: ecsnonact := '
3358: from pay_payroll_actions pay_pa1,
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,
3357: ecsnonact := '
3358: from pay_payroll_actions pay_pa1,
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
3380: --
3381: -- Restricted payroll action range row where clause.
3382: -- i.e. restricted by payroll_id.
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
3381: -- Restricted payroll action range row where clause.
3382: -- i.e. restricted by payroll_id.
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
3399: --
3400: -- Unrestricted payroll action range row where clause.
3401: -- i.e. not restricted by 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
3400: -- Unrestricted payroll action range row where clause.
3401: -- i.e. not restricted by 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
3417: --
3418: -- Restricted payroll action range row where clause.
3419: -- i.e. restricted by payroll_id.
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
3418: -- Restricted payroll action range row where clause.
3419: -- i.e. restricted by payroll_id.
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
3436: --
3437: -- Unrestricted payroll action range row where clause.
3438: -- i.e. not restricted by 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
3437: -- Unrestricted payroll action range row where clause.
3438: -- i.e. not restricted by 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
3464: -- and not exists clause to exclude people failing interlock rules.
3465: -- this one is for time independent legislation.
3466: intind := '
3467: and not exists (
3468: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3469: from pay_action_classifications pay_acl,
3470: pay_payroll_actions pay_pa2,
3471: pay_assignment_actions pay_ac2
3472: where pay_ac2.assignment_id = pay_asg.assignment_id
3466: intind := '
3467: and not exists (
3468: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3469: from pay_action_classifications pay_acl,
3470: pay_payroll_actions pay_pa2,
3471: pay_assignment_actions pay_ac2
3472: where pay_ac2.assignment_id = pay_asg.assignment_id
3473: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3474: and pay_acl.classification_name = ''SEQUENCED''
3478: and pay_pa2.effective_date <= pay_pac.effective_date)))';
3479: --
3480: intbal := '
3481: and not exists (
3482: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3483: from pay_action_classifications pay_acl,
3484: pay_payroll_actions pay_pa2,
3485: pay_assignment_actions pay_ac2
3486: where pay_ac2.assignment_id = pay_asg.assignment_id
3480: intbal := '
3481: and not exists (
3482: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */ null
3483: from pay_action_classifications pay_acl,
3484: pay_payroll_actions pay_pa2,
3485: pay_assignment_actions pay_ac2
3486: where pay_ac2.assignment_id = pay_asg.assignment_id
3487: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3488: and pay_acl.classification_name = ''SEQUENCED''
3556: intpur := '
3557: and not exists (
3558: select null
3559: from pay_assignment_actions pay_ac2,
3560: pay_payroll_actions pay_pa2
3561: where pay_ac2.assignment_id = pay_asg.assignment_id +decode(pay_pos.period_of_service_id,0,0,0)
3562: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3563: and pay_pa2.action_type = ''Z''
3564: and (pay_ac2.secondary_status <> ''C''
3565: or (pay_pa2.effective_date >= pay_pac.effective_date)))
3566: and exists (
3567: select null
3568: from pay_assignment_actions pay_ac4,
3569: pay_payroll_actions pay_pa4
3570: where pay_ac4.assignment_id = pay_asg.assignment_id +decode(pay_pos.period_of_service_id,0,0,0)
3571: and pay_pa4.payroll_action_id = pay_ac4.payroll_action_id
3572: and pay_pa4.effective_date <= pay_pac.effective_date
3573: and pay_pa4.action_type <> ''Z''
3574: and pay_pa4.effective_date >=
3575: (select nvl(max(pay_pa42.effective_date)
3576: ,hr_general.start_of_time)
3577: from pay_assignment_actions pay_ac42,
3578: pay_payroll_actions pay_pa42
3579: where pay_ac42.assignment_id = pay_asg.assignment_id +decode(pay_pos.period_of_service_id,0,0,0)
3580: and pay_pa42.payroll_action_id = pay_ac42.payroll_action_id
3581: and pay_pa42.action_type = ''Z''
3582: and pay_ac42.secondary_status = ''C''
3596: --
3597: -- Retropay sequence
3598: intretind := '
3599: and not exists (
3600: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */
3601: null
3602: from pay_action_classifications pay_acl,
3603: pay_payroll_actions pay_pa2,
3604: pay_assignment_actions pay_ac2
3599: and not exists (
3600: select /*+ INDEX (pay_pa2 pay_payroll_actions_pk) */
3601: null
3602: from pay_action_classifications pay_acl,
3603: pay_payroll_actions pay_pa2,
3604: pay_assignment_actions pay_ac2
3605: where pay_ac2.assignment_id = pay_asg.assignment_id
3606: and pay_pa2.payroll_action_id = pay_ac2.payroll_action_id
3607: and pay_acl.classification_name = ''SEQUENCED''
3612: and pay_pa2.effective_date <= pay_pac.effective_date)))';
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
3629: pay_asg.effective_start_date and pay_asg.effective_end_date';
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
3647: pay_asg.effective_start_date and pay_asg.effective_end_date';
3648: --
3649: retdefasgpg := '
3650: from
3651: pay_payroll_actions pay_pac,
3652: pay_object_groups pay_pos
3653: where pay_pac.payroll_action_id = :payroll_action_id
3654: and pay_pos.source_type = ''PPF''
3655: and exists (select ''''
3669: )';
3670: -- Bug 1308309, Quick-Retropay
3671: qretdefasgpg := '
3672: from
3673: pay_payroll_actions pay_pac,
3674: pay_object_groups pay_pos
3675: where pay_pac.payroll_action_id = :payroll_action_id
3676: and pay_pos.source_type = ''PPF''
3677: and exists (select ''''
3704: and not exists
3705: (select 1
3706: from pay_action_interlocks int,
3707: pay_assignment_actions aa9,
3708: pay_payroll_actions pay_ppa2
3709: where int.locked_action_id = pay_paa2.assignment_action_id
3710: and aa9.assignment_action_id = int.locking_action_id
3711: and pay_ppa2.payroll_action_id = aa9.payroll_action_id
3712: and pay_ppa2.action_type = ''V'')';
3712: and pay_ppa2.action_type = ''V'')';
3713:
3714: orgfrom := '
3715: from
3716: pay_payroll_actions pay_pac,
3717: hr_organization_units hou,
3718: hr_organization_information hoi
3719: where pay_pac.payroll_action_id = pay_proc_environment_pkg.get_pactid()
3720: and hou.business_group_id = pay_pac.business_group_id