[Home] [Help]
408: cursor csr_hire_date is
409: select pps.date_start
410: from per_periods_of_service pps,
411: per_assignments_f pa,
412: pay_assignment_actions paa
413: where paa.assignment_action_id = p_owner_assignment_action_id
414: and pa.assignment_id = paa.assignment_id
415: and p_owner_effective_date
416: between pa.effective_start_date and pa.effective_end_date
438: is
439: cursor csr_start_date is
440: select ppos.date_start
441: from per_periods_of_service ppos,
442: pay_assignment_actions pac,
443: per_assignments_f pa
444: Where pac.assignment_action_id = p_asg_action
445: and pac.assignment_id = pa.assignment_id
446: and ppos.period_of_service_id = pa.period_of_service_id
471: cursor csr_hire_date is
472: select pps.date_start
473: from per_periods_of_service pps,
474: per_assignments_f pa,
475: pay_assignment_actions paa
476: where paa.assignment_action_id = p_owner_assignment_action_id
477: and pa.assignment_id = paa.assignment_id
478: and p_owner_effective_date
479: between pa.effective_start_date and pa.effective_end_date
504:
505: cursor csr_run_type_name_assact is
506: select prt.run_type_name
507: from pay_run_types_f prt,
508: pay_assignment_actions paa,
509: pay_payroll_actions ppa
510: where paa.assignment_action_id = p_assact_id
511: and ppa.payroll_action_id = p_payroll_action_id
512: and prt.run_type_id = paa.run_type_id
768: fnd_date.canonical_to_date(prrv.result_value)
769: from pay_run_result_values prrv,
770: pay_run_results prr,
771: pay_payroll_actions ppa,
772: pay_assignment_actions paa,
773: pay_element_types_f pet,
774: pay_input_values_f piv
775: where
776: paa.assignment_action_id = p_assignment_action_id
791: min(greatest(ptp.start_date, trunc(ppa1.effective_date, 'YYYY')))
792: from per_time_periods ptp,
793: pay_run_types_f prt2,
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa1
799: where paa1.assignment_action_id = p_assignment_action_id
794: pay_payroll_actions ppa2,
795: pay_assignment_actions paa2,
796: pay_run_types_f prt1,
797: pay_payroll_actions ppa1,
798: pay_assignment_actions paa1
799: where paa1.assignment_action_id = p_assignment_action_id
800: and ppa1.payroll_action_id = paa1.payroll_action_id
801: and prt1.run_type_id = paa1.run_type_id
802: and ppa1.effective_date
817: /* Latest bonus with same run_type category as corrent bonus. */
818: select nvl(max(paa3.action_sequence), 0)
819: from pay_run_types_f prt3,
820: pay_payroll_actions ppa3,
821: pay_assignment_actions paa3
822: where paa3.assignment_id = paa1.assignment_id
823: and paa3.action_sequence < paa1.action_sequence
824: and ppa3.payroll_action_id = paa3.payroll_action_id
825: and ppa3.action_type in ('R', 'Q')
873: g_bonus_bon_period_start_date := g_bonus_pay_period_start_date;
874: end if;
875: --
876: -- 3. If legislative parameter BONUS_PERIOD_START_DATE is not set,
877: -- derive this parameter from PAY_ASSIGNMENT_ACTIONS table
878: -- and stores it in cache.
879: --
880: if (l_bonus_period_start_date is null and
881: g_bonus_pay_period_start_date is null) then
891: --
892: return g_bonus_bon_period_start_date;
893: end bonus_period_start_date;
894: --
895: Function inc_or_exc_assact (p_bal_asact in pay_assignment_actions.assignment_action_id%type
896: ,p_asact in pay_assignment_actions.assignment_action_id%type
897: ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type
898: ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 is
899:
892: return g_bonus_bon_period_start_date;
893: end bonus_period_start_date;
894: --
895: Function inc_or_exc_assact (p_bal_asact in pay_assignment_actions.assignment_action_id%type
896: ,p_asact in pay_assignment_actions.assignment_action_id%type
897: ,p_bal_asact_rtype_name in pay_run_types_f.run_type_name%type
898: ,p_asact_rtype_name in pay_run_types_f.run_type_name%type ) return varchar2 is
899:
900: