eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NO_EMP_CONT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 134: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

130: -- Cursor definitions
131:
132: -- csr to get the current assignment_action_ids with the same LE
133: cursor csr_curr_le_asg_act_id
134: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
135: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
136: ,p_date_earned DATE ) is
137: select pact.ASSIGNMENT_ACTION_ID
138: from pay_assignment_actions pact

Line 138: from pay_assignment_actions pact

134: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
135: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
136: ,p_date_earned DATE ) is
137: select pact.ASSIGNMENT_ACTION_ID
138: from pay_assignment_actions pact
139: ,pay_run_types_f prt
140: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
141: and pact.TAX_UNIT_ID = p_tax_unit_id
142: and prt.LEGISLATION_CODE = 'NO'

Line 152: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

148: ------------- Remove this
149: -- testing the number of rows returned by the above cursor
150: -- csr to get the current assignment_action_ids with the same LE
151: cursor csr_test_aag_act_id
152: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
153: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
154: ,p_date_earned DATE ) is
155: select count(*)
156: from pay_assignment_actions pact

Line 156: from pay_assignment_actions pact

152: (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
153: ,p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
154: ,p_date_earned DATE ) is
155: select count(*)
156: from pay_assignment_actions pact
157: ,pay_run_types_f prt
158: where pact.PAYROLL_ACTION_ID = p_payroll_action_id
159: and pact.TAX_UNIT_ID = p_tax_unit_id
160: and prt.LEGISLATION_CODE = 'NO'

Line 172: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS

168:
169: /*
170:
171: -- cursor to get STATUS from Legal Employer
172: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS
173: select ORG_INFORMATION3
174: from HR_ORGANIZATION_INFORMATION
175: where ORGANIZATION_ID = p_tax_unit_id
176: and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';

Line 1604: (p_assignment_action_id IN pay_assignment_actions.ASSIGNMENT_ACTION_ID%type

1600:
1601: -- function to check if person is under_62
1602:
1603: FUNCTION check_under_62
1604: (p_assignment_action_id IN pay_assignment_actions.ASSIGNMENT_ACTION_ID%type
1605: ,p_date_earned IN DATE) RETURN VARCHAR2 IS
1606:
1607: l_dob DATE;
1608: l_bimonth_start_date DATE;

Line 1618: ,pay_assignment_actions assact

1614: select date_of_birth
1615: into l_dob
1616: from per_all_people_f pap
1617: ,per_all_assignments_f asg
1618: ,pay_assignment_actions assact
1619: where assact.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1620: and assact.assignment_id = asg.assignment_id
1621: and p_date_earned between asg.effective_start_date and asg.effective_end_date
1622: and p_date_earned between pap.effective_start_date and pap.effective_end_date