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_IE_PAYPATH_TAPE dependencies on PAY_MAGTAPE_GENERIC

Line 67: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

63: FROM pay_all_payrolls_f papf
64: , hr_organization_information org
65: , hr_soft_coding_keyflex sck
66: WHERE
67: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
68: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
69: between papf.effective_start_date and papf.effective_end_date
70: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
71: and papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID

Line 68: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')

64: , hr_organization_information org
65: , hr_soft_coding_keyflex sck
66: WHERE
67: papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
68: and to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'),'YYYY/MM/DD HH24:MI:SS')
69: between papf.effective_start_date and papf.effective_end_date
70: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
71: and papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
72: and org.ORG_INFORMATION_ID = to_number(sck.segment2)

Line 84: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

80: SELECT org.org_information8
81: FROM hr_organization_information org
82: , pay_payroll_actions ppa
83: WHERE
84: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
85: and org.organization_id = ppa.business_group_id
86: and org.org_information_context = 'IE_PAYPATH_INFORMATION'
87: and rownum=1;
88:

Line 104: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')

100: , pay_all_payrolls_f papf
101: , pay_payroll_actions ppa
102: WHERE
103: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
104: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
105: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
106: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
107: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
108: and papf.payroll_id=ppa.payroll_id);

Line 105: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')

101: , pay_payroll_actions ppa
102: WHERE
103: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
104: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
105: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
106: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
107: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
108: and papf.payroll_id=ppa.payroll_id);
109:

Line 107: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')

103: papf.SOFT_CODING_KEYFLEX_ID = sck.SOFT_CODING_KEYFLEX_ID
104: and papf.payroll_id = pay_magtape_generic.get_parameter_value('PAYROLL_ID')
105: and papf.consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID')
106: and ppa.effective_date between papf.effective_start_date and papf.effective_end_date
107: and ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
108: and papf.payroll_id=ppa.payroll_id);
109:
110: l_paypath_ids csr_payrolls%rowtype;
111: l_bg_pathid csr_bg_paypath%rowtype;

Line 120: IF pay_magtape_generic.get_parameter_value('PAYROLL_ID') is null then

116:
117: BEGIN
118:
119: --Only consolidation set specified as parameter in IE PayPath Process
120: IF pay_magtape_generic.get_parameter_value('PAYROLL_ID') is null then
121:
122: BEGIN
123:
124: OPEN csr_payrolls;

Line 199: WHERE consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');

195: CURSOR csr_consolidation_name
196: IS
197: SELECT consolidation_set_name
198: FROM PAY_CONSOLIDATION_SETS
199: WHERE consolidation_set_id = pay_magtape_generic.get_parameter_value('CONSOLIDATION_SET_ID');
200:
201: l_consolidation_name varchar2(200);
202:
203: BEGIN