DBA Data[Home] [Help]

APPS.PAY_PL_UTILITY dependencies on PAY_ELEMENT_TYPES_F

Line 362: pay_element_types_f petf

358: pay_Assignment_actions paa,
359: per_time_periods ptp,
360: pay_all_payrolls_f papf,
361: pay_run_results prr,
362: pay_element_types_f petf
363: where paa.source_action_id is not null
364: and paa.assignment_id=r_assignment_id
365: and paa.action_status='C'
366: and ppa.action_type in ('R','Q')

Line 387: pay_element_types_f petf,

383: cursor csr_run_result_values(r_assignment_action_id number,r_element varchar2) is
384: select pivf.name,result_value,petf.element_name
385: from pay_run_results prr,
386: pay_run_result_values prrv,
387: pay_element_types_f petf,
388: pay_input_values_f pivf
389: where prr.assignment_action_id=r_assignment_action_id
390: and petf.legislation_code='PL'
391: and pivf.legislation_code='PL'