[Home] [Help]
4: g_param_issuing_estab_id per_all_assignments_f.establishment_id%type;
5: g_param_company_id hr_organization_information.organization_id%type;
6: g_param_estab_id hr_organization_information.organization_id%type;
7: g_effective_date Date;
8: g_assign_action_id pay_payroll_actions.payroll_action_id%type;
9: g_param_business_group_id hr_organization_information.organization_id%type;
10: g_param_reference VARCHAR2(100);
11: g_param_start_date Date;
12:
109: l_location_id per_all_assignments_f.location_id%type;
110:
111: p_id Number;
112: l_id2 per_all_people_f.employee_number%type;
113: l_pactid pay_payroll_actions.payroll_action_id%type;
114:
115: -- Local Variable Declaration for Exceptions
116: l_value fnd_new_messages.message_text%type;
117: l_error_type hr_lookups.meaning%type;
767: from pay_action_contexts pac
768: ,ff_contexts fc
769: ,pay_assignment_actions paa
770: ,pay_assignment_actions paa_date
771: ,pay_payroll_actions ppa
772: where pac.assignment_id = paa.assignment_id
773: and pac.assignment_action_id = paa.assignment_action_id
774: and fc.context_id = pac.context_id
775: and fc.context_name = 'SOURCE_TEXT'
1156: select ptp.end_date
1157: ,ptp.start_date
1158: from pay_action_interlocks pai
1159: , pay_assignment_actions paa
1160: , pay_payroll_actions ppa
1161: , per_time_periods ptp
1162: where pai.locking_action_id = g_assign_action_id
1163: and paa.assignment_action_id = pai.locked_action_id
1164: and ppa.payroll_action_id = paa.payroll_action_id
1606: BEGIN
1607: select max(ppa.date_earned)
1608: into c_start_date
1609: from pay_assignment_actions paa
1610: ,pay_payroll_actions ppa
1611: where paa.assignment_id = p_assignment_id
1612: and ppa.payroll_action_id = paa.payroll_action_id
1613: and ppa.date_earned < g_param_start_date
1614: and ppa.action_status = 'C'
3926: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
3927: paa.assignment_action_id),16)) assignment_action_id
3928: from pay_assignment_actions paa,
3929: pay_assignment_actions paa_pro,
3930: pay_payroll_actions ppa
3931: where paa.assignment_id = p_assignment_id
3932: and paa_pro.assignment_action_id (+) = paa.source_action_id
3933: and paa_pro.end_date(+) is not null
3934: and paa.end_date is null
3937: /* exclude reversal results and reversed run results */
3938: and ppa.action_type In ('R', 'Q', 'I')
3939: and NOT EXISTS
3940: (SELECT NULL
3941: FROM pay_payroll_actions RPACT
3942: , pay_assignment_actions RASSACT
3943: , pay_action_interlocks RINTLK
3944: where paa.assignment_action_id = RINTLK.locked_action_id
3945: and RINTLK.locking_action_id = RASSACT.assignment_action_id