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_DK_ARCHIVE_EIN dependencies on PAY_PAYROLL_ACTIONS

Line 99: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

95: p_parameter_string IN VARCHAR2
96: ,p_token IN VARCHAR2
97: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
98: IS
99: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
100: l_start_pos NUMBER;
101: l_delimiter VARCHAR2(1):=' ';
102: l_proc VARCHAR2(40):= g_package||' get parameter ';
103: BEGIN

Line 167: FROM pay_payroll_actions

163: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'COMPANY_TERMINATING')
164: ,PAY_DK_ARCHIVE_EIN.GET_PARAMETER(legislative_parameters,'SENDER_ID')
165: ,effective_date
166: ,business_group_id
167: FROM pay_payroll_actions
168: WHERE payroll_action_id = p_payroll_action_id;
169:
170: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
171: --

Line 324: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';

320: IF g_debug THEN
321: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
322: END IF;
323:
324: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
325:
326: g_legal_employer_id := NULL ;
327: g_effective_date := NULL ;
328: g_start_date := NULL; /* 9489806 */

Line 707: FROM pay_payroll_actions ppa

703: SELECT as1.person_id person_id,
704: act.assignment_id assignment_id,
705: act.assignment_action_id run_action_id,
706: act1.assignment_action_id prepaid_action_id
707: FROM pay_payroll_actions ppa
708: ,pay_payroll_actions appa
709: ,pay_payroll_actions appa2
710: ,pay_assignment_actions act
711: ,pay_assignment_actions act1

Line 708: ,pay_payroll_actions appa

704: act.assignment_id assignment_id,
705: act.assignment_action_id run_action_id,
706: act1.assignment_action_id prepaid_action_id
707: FROM pay_payroll_actions ppa
708: ,pay_payroll_actions appa
709: ,pay_payroll_actions appa2
710: ,pay_assignment_actions act
711: ,pay_assignment_actions act1
712: ,pay_action_interlocks pai

Line 709: ,pay_payroll_actions appa2

705: act.assignment_action_id run_action_id,
706: act1.assignment_action_id prepaid_action_id
707: FROM pay_payroll_actions ppa
708: ,pay_payroll_actions appa
709: ,pay_payroll_actions appa2
710: ,pay_assignment_actions act
711: ,pay_assignment_actions act1
712: ,pay_action_interlocks pai
713: ,per_all_assignments_f as1

Line 1115: from pay_assignment_actions pac, pay_payroll_actions ppa

1111: lr_Get_Defined_Balance_Id csr_Get_Defined_Balance_Id%rowtype;
1112:
1113: CURSOR csr_asg_action_id(assg_id NUMBER, pid NUMBER, tid NUMBER, le_id NUMBER) IS
1114: select MAX(pac.ASSIGNMENT_ACTION_ID) id
1115: from pay_assignment_actions pac, pay_payroll_actions ppa
1116: where ppa.action_type IN ('R','Q')
1117: and pac.payroll_action_id = ppa.payroll_action_id
1118: and pac.assignment_id= assg_id
1119: and ppa.payroll_id=pid

Line 1142: FROM pay_payroll_actions ppa

1138: l_canonical_end_date DATE,
1139: l_assignment_id NUMBER)
1140: IS
1141: SELECT 1
1142: FROM pay_payroll_actions ppa
1143: ,pay_payroll_actions appa
1144: ,pay_payroll_actions appa2
1145: ,pay_assignment_actions act
1146: ,pay_assignment_actions act1

Line 1143: ,pay_payroll_actions appa

1139: l_assignment_id NUMBER)
1140: IS
1141: SELECT 1
1142: FROM pay_payroll_actions ppa
1143: ,pay_payroll_actions appa
1144: ,pay_payroll_actions appa2
1145: ,pay_assignment_actions act
1146: ,pay_assignment_actions act1
1147: ,pay_action_interlocks pai

Line 1144: ,pay_payroll_actions appa2

1140: IS
1141: SELECT 1
1142: FROM pay_payroll_actions ppa
1143: ,pay_payroll_actions appa
1144: ,pay_payroll_actions appa2
1145: ,pay_assignment_actions act
1146: ,pay_assignment_actions act1
1147: ,pay_action_interlocks pai
1148: ,per_all_assignments_f as1

Line 1189: pay_payroll_actions ppa

1185:
1186: CURSOR cur_max_asg_act_id(p_assignment_id NUMBER, p_start_date DATE, p_end_date DATE) IS
1187: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
1188: FROM pay_assignment_actions paa,
1189: pay_payroll_actions ppa
1190: WHERE ppa.payroll_action_id = paa.payroll_action_id
1191: and paa.assignment_id = p_assignment_id
1192: and ppa.action_type in ('R','Q','I','B','V')
1193: and paa.source_action_id is null

Line 1198: FROM pay_payroll_actions ppa

1194: AND ppa.effective_date between p_start_date AND p_end_date;
1195:
1196: CURSOR cur_table_val_exist_400(p_payroll_action_id number) IS
1197: SELECT 'Y'
1198: FROM pay_payroll_actions ppa
1199: , pay_user_tables put
1200: , pay_user_columns puc
1201: , pay_user_column_instances_f puci
1202: , pay_user_rows_f pur

Line 3834: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

3830: RAISE;
3831: END ARCHIVE_CODE;
3832:
3833: PROCEDURE DEINITIALIZATION_CODE
3834: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
3835:
3836: /* Cursors to fetch data for record numbering*/
3837:
3838: CURSOR csr_all_rec_2001 ( p_payroll_action_id NUMBER) IS