DBA Data[Home] [Help]

APPS.PAY_CA_WF_PKG dependencies on PAY_RUN_TYPES_F

Line 847: from pay_run_types_f_tl t,

843: and payroll_id = l_payroll_id;
844:
845: cursor cur_payroll_run_type is
846: select t.run_type_name
847: from pay_run_types_f_tl t,
848: pay_run_types_f r
849: where r.run_type_id = to_number(p_payroll_run_type)
850: and r.run_type_id = t.run_type_id
851: and t.language = userenv('LANG')

Line 848: pay_run_types_f r

844:
845: cursor cur_payroll_run_type is
846: select t.run_type_name
847: from pay_run_types_f_tl t,
848: pay_run_types_f r
849: where r.run_type_id = to_number(p_payroll_run_type)
850: and r.run_type_id = t.run_type_id
851: and t.language = userenv('LANG')
852: and fnd_date.canonical_to_date(p_date_earned)

Line 2976: from pay_run_types_f_tl t,

2972: and payroll_id = l_payroll_id;
2973:
2974: cursor cur_payroll_run_type is
2975: select t.run_type_name
2976: from pay_run_types_f_tl t,
2977: pay_run_types_f r
2978: where r.run_type_id = to_number(p_payroll_run_type)
2979: and r.run_type_id = t.run_type_id
2980: and t.language = userenv('LANG')

Line 2977: pay_run_types_f r

2973:
2974: cursor cur_payroll_run_type is
2975: select t.run_type_name
2976: from pay_run_types_f_tl t,
2977: pay_run_types_f r
2978: where r.run_type_id = to_number(p_payroll_run_type)
2979: and r.run_type_id = t.run_type_id
2980: and t.language = userenv('LANG')
2981: and fnd_date.canonical_to_date(p_date_earned)