APPS.PAY_FR_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 142: , pay_element_types_f pet

138:
139: cursor pay_run_result_csr is
140: select prrv.result_value
141: from pay_run_results prr
142: , pay_element_types_f pet
143: , pay_input_values_f piv
144: , pay_run_result_values prrv
145: where prr.assignment_action_id = g_prior_asg_action_id
146: and prr.element_type_id = pet.element_type_id

Line 1260: , pay_element_types_f pet

1256: select min(paa.date_start)
1257: from pay_balance_types pbt
1258: , pay_balance_feeds_f pbf
1259: , pay_input_values_f piv
1260: , pay_element_types_f pet
1261: , pay_element_entries_f pee
1262: , pay_element_links_f pel
1263: , per_absence_attendances paa
1264: where pbt.balance_name = 'FR_SICKNESS_ABSENCE_DAYS'

Line 1321: , pay_element_types_f pet

1317: sum(paa.absence_days)
1318: from pay_balance_types pbt
1319: , pay_balance_feeds_f pbf
1320: , pay_input_values_f piv
1321: , pay_element_types_f pet
1322: , pay_element_entries_f pee
1323: , pay_element_links_f pel
1324: , per_absence_attendances paa
1325: , pay_element_entries_f pee2

Line 1327: , pay_element_types_f pet2

1323: , pay_element_links_f pel
1324: , per_absence_attendances paa
1325: , pay_element_entries_f pee2
1326: , pay_element_links_f pel2
1327: , pay_element_types_f pet2
1328: where pbt.balance_name = 'FR_SICKNESS_ABSENCE_DAYS'
1329: and pbt.business_group_id IS NULL
1330: and pbt.legislation_code = 'FR'
1331: and pbt.balance_type_id = pbf.balance_type_id

Line 1762: l_element_name pay_element_types_f.element_name%type;

1758: l_base_name varchar2(30);
1759: l_user_column_instance_id number;
1760: l_user_row_id number;
1761: l_rate_category varchar2(1);
1762: l_element_name pay_element_types_f.element_name%type;
1763: l_transport_tax_region varchar2(80);
1764:
1765: l_contribution_usage_row pay_fr_contribution_usages%rowtype := get_contribution_usage(
1766: p_process_type => g_process_type