APPS.PAY_HK_SOE_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 432: FROM pay_payroll_actions ppa

428:
429: CURSOR csr_get_date_earned
430: IS
431: SELECT ppa.date_earned, paa.tax_unit_id
432: FROM pay_payroll_actions ppa
433: , pay_assignment_actions paa
434: WHERE ppa.payroll_action_id = paa.payroll_action_id
435: AND paa.assignment_action_id = p_assignment_action_id;
436:

Line 587: l_effective_date pay_payroll_actions.effective_date%TYPE;

583: IS
584:
585: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
586: l_business_group_id per_business_groups.business_group_id%TYPE;
587: l_effective_date pay_payroll_actions.effective_date%TYPE;
588:
589: CURSOR csr_prepayment
590: IS
591: SELECT MAX(locked_action_id)

Line 598: FROM pay_payroll_actions ppa

594:
595: CURSOR csr_get_bg_id
596: IS
597: SELECT ppa.business_group_id,ppa.effective_date
598: FROM pay_payroll_actions ppa
599: ,pay_assignment_actions paa
600: WHERE ppa.payroll_action_id = paa.payroll_action_id
601: AND paa.assignment_action_id = p_assignment_action_id;
602:

Line 696: FROM pay_payroll_actions ppa

692:
693: CURSOR csr_get_date_earned
694: IS
695: SELECT ppa.date_earned, ppa.business_group_id, paa.tax_unit_id
696: FROM pay_payroll_actions ppa
697: , pay_assignment_actions paa
698: WHERE ppa.payroll_action_id = paa.payroll_action_id
699: AND paa.assignment_action_id = p_assignment_action_id;
700:

Line 784: ,pay_payroll_actions ppa

780: ,pay_element_types_f pet
781: ,pay_element_links_f pel
782: ,pay_element_entries_f pee
783: ,pay_assignment_actions paa
784: ,pay_payroll_actions ppa
785: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
786: AND pel.element_type_id = pet.element_type_id
787: AND pee.element_link_id = pel.element_link_id
788: AND paa.assignment_id = pee.assignment_id

Line 807: FROM pay_payroll_actions ppa

803:
804: CURSOR csr_get_date_earned(c_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE)
805: IS
806: SELECT ppa.date_earned
807: FROM pay_payroll_actions ppa
808: , pay_assignment_actions paa
809: WHERE ppa.payroll_action_id = paa.payroll_action_id
810: AND paa.assignment_action_id = c_assignment_action_id;
811:

Line 942: ,pay_payroll_actions ppa

938: ,TO_CHAR(decode(pet.processing_type,''R'',least(pab.date_end,PTP.END_DATE),pab.date_end),''DD-Mon-YYYY'') COL03
939: ,hr_general.decode_lookup(''HOURS_OR_DAYS'',pat.HOURS_OR_DAYS) COL04
940: ,TO_CHAR(decode(pet.processing_type,''R'',to_number(prrv.result_value),nvl(pab.absence_days,pab.absence_hours))) COL16
941: FROM pay_assignment_actions paa
942: ,pay_payroll_actions ppa
943: ,pay_run_results prr
944: ,pay_run_result_values prrv
945: ,per_time_periods ptp
946: ,pay_element_types_f pet