APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_USER_TABLES

Line 1139: FROM pay_user_tables t

1135: decode(hoi.org_information4,'RRV',NULL,hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'ASG_INFO_DFN'))) asg_info_dfn
1136: ,nvl(hoi.org_information14, hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_METH')) rep_summ_meth
1137: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1138: decode(hoi.org_information14, 'PROCEDURE', hr_de_general.get_uci(p_report_date,t.user_table_id,r.user_row_id,'REP_SUMM_DFN'))) rep_summ_dfn
1139: FROM pay_user_tables t
1140: ,pay_user_rows_f r
1141: ,hr_organization_information hoi
1142: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1143: AND t.legislation_code = 'NO'

Line 1187: ,pay_user_tables t

1183: ,t.user_table_id
1184: ,r.user_row_id
1185: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_XML_CODE_MAP') XML_VALUE_MAP --2007/08 changes
1186: FROM pay_user_rows_f r
1187: ,pay_user_tables t
1188: ,pay_user_columns c
1189: ,pay_user_column_instances_f ci
1190: ,hr_organization_information hoi
1191: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'

Line 1238: ,pay_user_tables t

1234: ,hr_lookups lu
1235: ,hr_organization_information orginf1
1236: ,hr_all_organization_units org2
1237: ,hr_organization_information orginf2
1238: ,pay_user_tables t
1239: ,pay_user_rows_f r
1240: WHERE ppa.business_group_id = p_business_group_id
1241: AND paa.payroll_action_id = ppa.payroll_action_id
1242: AND pac1.assignment_action_id = paa.assignment_action_id

Line 1823: ,pay_user_tables t

1819: ,pay_action_contexts ac2
1820: ,ff_contexts ctx2
1821: ,pay_action_contexts ac3
1822: ,ff_contexts ctx3
1823: ,pay_user_tables t
1824: ,pay_user_rows_f r
1825: WHERE asg.person_id BETWEEN p_start_person AND p_end_person
1826: AND paa.assignment_id = asg.assignment_id
1827: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2121: ,pay_user_tables t

2117: ,pay_payroll_actions ppa
2118: ,pay_run_results rr
2119: ,pay_run_result_values rrv
2120: ,pay_input_values_f pivf
2121: ,pay_user_tables t
2122: ,pay_user_rows_f r
2123: ,pay_element_entries_f pee
2124: WHERE cde_dtl.action_context_type = 'PA'
2125: AND cde_dtl.action_context_id = p_payroll_action_id

Line 2298: ,pay_user_tables t

2294: ,pay_run_results rr
2295: ,pay_run_result_values rrv
2296: ,pay_input_values_f pivf
2297: ,pay_element_types_f petf
2298: ,pay_user_tables t
2299: ,pay_user_rows_f r
2300: WHERE ppa.business_group_id = p_business_group_id
2301: AND ppa.action_type IN ('R','Q','I','B')
2302: AND ppa.action_status = 'C'

Line 2374: ,pay_user_tables t

2370: ,pay_run_results rr
2371: ,pay_run_result_values rrv
2372: ,pay_input_values_f pivf
2373: ,pay_element_types_f petf
2374: ,pay_user_tables t
2375: ,pay_user_rows_f r
2376: WHERE ppa.business_group_id = p_business_group_id
2377: AND ppa.action_type IN ('R','Q','I','B')
2378: AND ppa.action_status = 'C'