[Home] [Help]
175: PPA.EFFECTIVE_DATE DATE_PAID,
176: ptp.end_date DATE_EARNED,
177: ptp.TIME_PERIOD_ID,
178: ptp.PAYROLL_ID
179: FROM PAY_PAYROLL_ACTIONS PPA,
180: PAY_ASSIGNMENT_ACTIONS PAA,
181: PER_TIME_PERIODS PTP
182: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
183: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
687: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
688: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
689: PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS,'MODE') L_MODE,
690: BUSINESS_GROUP_ID
691: FROM PAY_PAYROLL_ACTIONS
692: WHERE PAYROLL_ACTION_ID = G_PAYROLL_ACTION_ID ;
693: --Tax details Reference for staging date and postponement rule.
694: CURSOR C_TAX_REF_PENSION_DETAILS
695: IS
868: CURSOR C_ACTION_IDS(P_ASSIGNMENT_ID NUMBER )
869: IS
870: SELECT PAA.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID ,
871: PPA.PAYROLL_ACTION_ID PAYROLL_ACTION_ID
872: FROM PAY_PAYROLL_ACTIONS PPA,
873: PAY_ASSIGNMENT_ACTIONS PAA
874: WHERE PPA.ACTION_TYPE IN ('Q','R')
875: AND PAA.ACTION_STATUS = 'C'
876: AND PPA.BUSINESS_GROUP_ID = G_BUSINESS_GROUP_ID
1150: ptp.end_date DATE_EARNED,
1151: ptp.TIME_PERIOD_ID,
1152: ptp.PAYROLL_ID,
1153: PRT.RUN_TYPE_NAME
1154: FROM PAY_PAYROLL_ACTIONS PPA,
1155: PAY_ASSIGNMENT_ACTIONS PAA,
1156: PAY_RUN_TYPES_F PRT,
1157: PER_TIME_PERIODS PTP
1158: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1181: AND peef.element_type_id NOT IN
1182: (SELECT DISTINCT prr.ELEMENT_TYPE_ID
1183: FROM pay_run_results prr,
1184: pay_assignment_actions paa,
1185: pay_payroll_actions ppa
1186: WHERE paa.assignment_action_id = prr.assignment_action_id
1187: AND paa.payroll_action_id = ppa.payroll_action_id
1188: AND ppa.time_period_id = P_TIME_PERIOD_ID
1189: AND SOURCE_ACTION_ID IS NOT NULL
1291: )
1292: AND regular_payment_date BETWEEN G_PRP_START_DATE AND G_PRP_END_DATE
1293: AND regular_payment_date NOT IN
1294: (SELECT effective_date
1295: FROM pay_payroll_actions ppa ,
1296: pay_assignment_actions paa ,
1297: per_time_periods ptp
1298: WHERE ppa.action_type IN ('Q', 'R')
1299: AND ppa.payroll_action_id = paa.payroll_action_id
1701:
1702: CURSOR c_payroll_run
1703: (p_assignment_id IN number) IS
1704: SELECT ppa.payroll_action_id
1705: FROM pay_payroll_actions ppa
1706: , pay_assignment_actions paa
1707: WHERE ppa.time_period_id = nvl (g_time_period_id, ppa.time_period_id)
1708: AND paa.assignment_id = p_assignment_id
1709: AND ppa.effective_date
3091: CURSOR get_asg_action_id
3092: IS
3093: SELECT DISTINCT paa.assignment_action_id asg_action_id,
3094: assignment_id
3095: FROM pay_payroll_actions ppa,
3096: pay_assignment_actions paa
3097: WHERE ppa.payroll_action_id = G_PAYROLL_ACTION_ID -- pact_id
3098: AND paa.payroll_action_id = ppa.payroll_action_id
3099: AND paa.action_status = 'C'
3112: CURSOR get_asg_action_id_error
3113: IS
3114: SELECT DISTINCT paa.assignment_action_id asg_action_id,
3115: assignment_id
3116: FROM pay_payroll_actions ppa,
3117: pay_assignment_actions paa
3118: WHERE ppa.payroll_action_id = G_PAYROLL_ACTION_ID -- pact_id
3119: AND paa.payroll_action_id = ppa.payroll_action_id
3120: AND
3233: IS
3234: SELECT TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PAYROLL_ID')) PAYROLL_ID,
3235: TO_NUMBER(PAY_GB_EOY_ARCHIVE.GET_PARAMETER(LEGISLATIVE_PARAMETERS, 'PERIOD_ID')) TIME_PERIOD_ID,
3236: BUSINESS_GROUP_ID
3237: FROM PAY_PAYROLL_ACTIONS
3238: WHERE PAYROLL_ACTION_ID = p_payroll_action_id ;
3239: l_act_payroll_id NUMBER;
3240: l_act_time_period_id NUMBER;
3241: l_act_business_id NUMBER;
3254: CLOSE CSR_ACT_CP_INFO;
3255: hr_utility.trace('Debugging - l_act_payroll_id: '||l_act_payroll_id);
3256: hr_utility.trace('Debugging - G_PAYROLL_END_DATE: '||G_PAYROLL_END_DATE);
3257: hr_utility.trace('Debugging - l_act_business_id: '||l_act_business_id);
3258: UPDATE pay_payroll_actions
3259: SET time_period_id = l_act_time_period_id ,
3260: payroll_id = l_act_payroll_id ,
3261: date_earned = G_PAYROLL_END_DATE ,
3262: effective_date = G_PAYROLL_DATE_PAID
3323: RAISE_APPLICATION_ERROR (-20001,'Please check the Staging Date / Default Pension Scheme if they are properly set up.') ;
3324: END IF;-- Staging Date
3325: bug 16178067 */
3326: /* IF G_BUSINESS_GROUP_ID IS NOT NULL AND G_PAYROLL_ID IS NOT NULL AND G_PRP_END_DATE IS NOT NULL THEN
3327: sqlstr := 'select distinct ppf.person_id ' || 'from per_people_f ppf, ' || 'pay_payroll_actions ppa, ' || 'per_all_assignments_f paaf, ' || 'per_assignment_status_types past ' ||
3328: 'where ppa.payroll_action_id = :PAYROLL_ACTION_ID ' || ' and ppa.business_group_id = ' ||G_BUSINESS_GROUP_ID || ' and paaf.payroll_id = ' ||G_PAYROLL_ID || ' and paaf.person_id = ppf.person_id ' ||
3329: ' and paaf.assignment_status_type_id = past.assignment_status_type_id ' || 'and past.PER_SYSTEM_status=''ACTIVE_ASSIGN'' ' || 'and ' ||''''||
3330: G_PRP_END_DATE ||''''||' between paaf.effective_start_date and paaf.effective_end_date ' || 'order by ppf.person_id' ;
3331: ELSIF G_PAYROLL_ID IS NOT NULL THEN
3332: */ -- bug 14813352
3333: IF G_PAYROLL_ID IS NOT NULL THEN
3334: -- Payroll ID used in param, restrict by this.
3335: hr_utility.set_location(l_proc,20);
3336: sqlstr := 'select distinct paaf.person_id '|| 'from pay_payroll_actions ppa, '|| 'per_all_assignments_f paaf '|| 'where ppa.payroll_action_id = :payroll_action_id '||
3337: 'and paaf.business_group_id + 0 = ppa.business_group_id '|| 'and paaf.payroll_id = '||G_PAYROLL_ID|| ' order by paaf.person_id';
3338: ELSE
3339: sqlstr := 'select distinct person_id '|| 'from per_people_f ppf, '|| 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '|| 'and ppa.business_group_id = ppf.business_group_id '||
3340: 'order by ppf.person_id';
3335: hr_utility.set_location(l_proc,20);
3336: sqlstr := 'select distinct paaf.person_id '|| 'from pay_payroll_actions ppa, '|| 'per_all_assignments_f paaf '|| 'where ppa.payroll_action_id = :payroll_action_id '||
3337: 'and paaf.business_group_id + 0 = ppa.business_group_id '|| 'and paaf.payroll_id = '||G_PAYROLL_ID|| ' order by paaf.person_id';
3338: ELSE
3339: sqlstr := 'select distinct person_id '|| 'from per_people_f ppf, '|| 'pay_payroll_actions ppa '|| 'where ppa.payroll_action_id = :payroll_action_id '|| 'and ppa.business_group_id = ppf.business_group_id '||
3340: 'order by ppf.person_id';
3341: END IF;
3342: hr_utility.trace(' Payroll Action Id : '||pactid);
3343: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
3472: --this is a eText report, Spawn the BI Publisher process
3473: hr_utility.trace('Spawn the BI Publisher process');
3474: WRITE_OUTPUT();
3475: /* Commented for bug 14273214 as this values are needed to be viewed in the Payroll view Form
3476: UPDATE pay_payroll_actions
3477: SET time_period_id = null
3478: , payroll_id = null
3479: , date_earned = null
3480: WHERE payroll_action_id = pactid
3576: )
3577: AND regular_payment_date BETWEEN L_PRP_START_DATE AND L_PRP_END_DATE
3578: AND regular_payment_date NOT IN
3579: (SELECT effective_date
3580: FROM pay_payroll_actions ppa ,
3581: pay_assignment_actions paa ,
3582: per_time_periods ptp
3583: WHERE ppa.action_type IN ('Q', 'R')
3584: AND ppa.payroll_action_id = paa.payroll_action_id