[Home] [Help]
6036: l_business_group_id number;
6037: l_consolidation_set_id number;
6038: --
6039: cursor C_CON1 is
6040: select pay_payroll_actions_s.nextval,
6041: pay_assignment_actions_s.nextval,
6042: pa.CONSOLIDATION_SET_ID,
6043: pa.BUSINESS_GROUP_ID
6044: from PAY_ASSIGNMENT_ACTIONS paa,
6712: select /*+ ordered use_nl(pee asg ptp pbg)
6713: index(pee PAY_ELEMENT_ENTRIES_F_PK)
6714: index(asg PER_ASSIGNMENTS_F_PK)
6715: index(ptp PER_TIME_PERIODS_N50) */
6716: pay_payroll_actions_s.nextval,
6717: asg.business_group_id,
6718: pbg.legislation_code,
6719: asg.assignment_id,
6720: asg.payroll_id,
6793: 'C',
6794: 'C',
6795: effdate,
6796: dtearned,
6797: pay_payroll_actions_s.nextval,
6798: tperiod,
6799: prepay_flag,
6800: creatby,
6801: creatdate,
8718: hrassact.gv_dum_qpay := FALSE ;
8719: hr_utility.set_location ('hrassact.ins_dummy_quickpay_action', 30);
8720:
8721: if v_payroll_action_id is not null and v_assignment_action_id is not null then
8722: /*Inserting the action sequence in pay_payroll_actions since
8723: it is not inserted by the previous called api
8724: also inserting the batch_process_mode as DUM_QPAY to indicate
8725: the payrollaction is inserted using this code*/
8726:
8724: also inserting the batch_process_mode as DUM_QPAY to indicate
8725: the payrollaction is inserted using this code*/
8726:
8727: update pay_payroll_actions
8728: set action_sequence = pay_payroll_actions_s.nextval,
8729: batch_process_mode = 'DUM_QPAY'
8730: where payroll_action_id = v_payroll_action_id
8731: and action_sequence is null;
8732: