APPS.PAY_NO_EOY_ARCHIVE dependencies on PAY_USER_TABLES

Line 1021: FROM pay_user_tables t

1017: 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
1018: ,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
1019: ,nvl(DECODE(hoi.org_information14,'PROCEDURE' , hoi.org_information15),
1020: 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
1021: FROM pay_user_tables t
1022: ,pay_user_rows_f r
1023: ,hr_organization_information hoi
1024: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'
1025: AND t.legislation_code = 'NO'

Line 1064: ,pay_user_tables t

1060: ,t.user_table_id
1061: ,r.user_row_id
1062: ,SUBSTR(c.user_column_name, 1, INSTR(c.user_column_name, '_') - 1) || '_XML_CODE_MAP') XML_VALUE_MAP --2007/08 changes
1063: FROM pay_user_rows_f r
1064: ,pay_user_tables t
1065: ,pay_user_columns c
1066: ,pay_user_column_instances_f ci
1067: ,hr_organization_information hoi
1068: WHERE t.user_table_name = 'NO_EOY_CODE_REPORTING_RULES'

Line 1110: ,pay_user_tables t

1106: ,hr_lookups lu
1107: ,hr_organization_information orginf1
1108: ,hr_all_organization_units org2
1109: ,hr_organization_information orginf2
1110: ,pay_user_tables t
1111: ,pay_user_rows_f r
1112: WHERE ppa.business_group_id = p_business_group_id
1113: AND paa.payroll_action_id = ppa.payroll_action_id
1114: AND pac1.assignment_action_id = paa.assignment_action_id

Line 1642: ,pay_user_tables t

1638: ,pay_action_contexts ac2
1639: ,ff_contexts ctx2
1640: ,pay_action_contexts ac3
1641: ,ff_contexts ctx3
1642: ,pay_user_tables t
1643: ,pay_user_rows_f r
1644: WHERE asg.person_id BETWEEN p_start_person AND p_end_person
1645: AND paa.assignment_id = asg.assignment_id
1646: AND ppa.payroll_action_id = paa.payroll_action_id

Line 1937: ,pay_user_tables t

1933: ,pay_payroll_actions ppa
1934: ,pay_run_results rr
1935: ,pay_run_result_values rrv
1936: ,pay_input_values_f pivf
1937: ,pay_user_tables t
1938: ,pay_user_rows_f r
1939: WHERE cde_dtl.action_context_type = 'PA'
1940: AND cde_dtl.action_context_id = p_payroll_action_id
1941: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'

Line 2054: ,pay_user_tables t

2050: ,pay_run_results rr
2051: ,pay_run_result_values rrv
2052: ,pay_input_values_f pivf
2053: ,pay_element_types_f petf
2054: ,pay_user_tables t
2055: ,pay_user_rows_f r
2056: WHERE ppa.business_group_id = p_business_group_id
2057: AND ppa.action_type IN ('R','Q','I','B')
2058: AND ppa.action_status = 'C'

Line 2115: ,pay_user_tables t

2111: ,pay_run_results rr
2112: ,pay_run_result_values rrv
2113: ,pay_input_values_f pivf
2114: ,pay_element_types_f petf
2115: ,pay_user_tables t
2116: ,pay_user_rows_f r
2117: WHERE ppa.business_group_id = p_business_group_id
2118: AND ppa.action_type IN ('R','Q','I','B')
2119: AND ppa.action_status = 'C'