APPS.PAY_IN_EOY_REPORTS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 195: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;

191: AND pai.Action_information1 = p_gre_id
192: AND pai.action_information3 = p_assessment_year;
193: --
194: l_procedure VARCHAR2(100);
195: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
196: --
197: BEGIN
198: g_debug := hr_utility.debug_enabled;
199: l_procedure := g_package ||'get_max_context_id';

Line 608: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;

604: l_pymt_date VARCHAR2(240);
605: l_procedure VARCHAR2(100);
606: l_open_tag VARCHAR2(100);
607: l_last_quarter VARCHAR2(10);
608: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
609:
610:
611: BEGIN
612: g_debug := hr_utility.debug_enabled;

Line 715: PROCEDURE build_employee_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE

711: -- p_source_id NUMBER --
712: -- p_rem_pay_period NUMBER --
713: -- p_flag NUMBER --
714: --------------------------------------------------------------------------
715: PROCEDURE build_employee_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
716: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
717: ,p_rem_pay_period OUT NOCOPY NUMBER
718: ,p_flag OUT NOCOPY NUMBER
719: )

Line 872: PROCEDURE build_form16_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE

868: -- p_source_id NUMBER --
869: -- p_rem_pay_period NUMBER --
870: -- p_flag NUMBER --
871: --------------------------------------------------------------------------
872: PROCEDURE build_form16_xml (p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
873: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE
874: ,p_rem_pay_period IN NUMBER
875: ,p_flag IN NUMBER
876: ,p_flag_for_16aa OUT NOCOPY NUMBER)

Line 1123: FROM pay_assignment_actions

1119: ,pay_element_entry_values_f value
1120: ,pay_element_links_f links
1121: WHERE assign.assignment_id =
1122: (SELECT assignment_id
1123: FROM pay_assignment_actions
1124: WHERE assignment_action_id = p_action_context_id)
1125: AND links.element_type_id = type.element_type_id
1126: AND links.element_type_id = entries.element_type_id
1127: AND links.element_link_id = entries.element_link_id

Line 1161: FROM pay_assignment_actions

1157: ,pay_element_entry_values_f value
1158: ,pay_element_links_f links
1159: WHERE assign.assignment_id =
1160: (SELECT assignment_id
1161: FROM pay_assignment_actions
1162: WHERE assignment_action_id = p_action_context_id)
1163: AND links.element_type_id = type.element_type_id
1164: AND links.element_type_id = entries.element_type_id
1165: AND links.element_link_id = entries.element_link_id

Line 1741: PROCEDURE build_form12ba_xml(p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE

1737: -- --
1738: -- Parameters : --
1739: -- IN : p_action_context_id NUMBER --
1740: --------------------------------------------------------------------------
1741: PROCEDURE build_form12ba_xml(p_action_context_id IN pay_assignment_actions.assignment_action_id%TYPE
1742: ,p_source_id IN pay_payroll_actions.payroll_action_id%TYPE)
1743: IS
1744: l_total_taxable_perq NUMBER;
1745: l_total_emp_contr NUMBER;

Line 1992: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;

1988: IS
1989: l_procedure VARCHAR2(100);
1990: l_open_tag VARCHAR2(100);
1991: l_gre_id hr_organization_units.organization_id%TYPE;
1992: l_action_context_id pay_assignment_actions.assignment_action_id%TYPE;
1993: l_emp_number per_people_f.employee_number%TYPE;
1994: l_emp_count NUMBER;
1995: l_start_date DATE;
1996: l_end_date DATE;

Line 2061: FROM pay_assignment_actions paa

2057: AND pai.action_information2 = p_assessment_year
2058: AND pai.action_information3 = p_gre_id
2059: AND pai.action_context_id = p_action_context_id
2060: AND EXISTS (SELECT 1
2061: FROM pay_assignment_actions paa
2062: ,pay_payroll_actions ppa
2063: WHERE pai.source_id = paa.assignment_action_id
2064: AND paa.payroll_action_id = ppa.payroll_action_id
2065: AND ppa.business_group_id = p_business_group_id );