APPS.PAY_ASG_LINK_USAGES_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 82: pay_element_links_f el,

78: asg.business_group_id,
79: el.element_link_id
80: from per_all_assignments_f asg,
81: pay_people_groups ppg,
82: pay_element_links_f el,
83: pay_people_groups el_pg
84: where el_pg.id_flex_num = ppg.id_flex_num
85: and el.element_link_id = p_element_link_id
86: and el.business_group_id + 0 = asg.business_group_id

Line 146: l_lnk_emp_cat pay_element_links_f.employment_category%type;

142: type segment_table is table of varchar2(60)
143: index by binary_integer;
144: segment segment_table;
145: l_lnk_org_id number;
146: l_lnk_emp_cat pay_element_links_f.employment_category%type;
147: l_lnk_payroll_id pay_element_links_f.payroll_id%type;
148: i number;
149: sql_curs number;
150: rows_processed integer;

Line 147: l_lnk_payroll_id pay_element_links_f.payroll_id%type;

143: index by binary_integer;
144: segment segment_table;
145: l_lnk_org_id number;
146: l_lnk_emp_cat pay_element_links_f.employment_category%type;
147: l_lnk_payroll_id pay_element_links_f.payroll_id%type;
148: i number;
149: sql_curs number;
150: rows_processed integer;
151: statem varchar2(8000);

Line 377: from pay_element_links_f

373: segment(30) := lpg.segment30;
374: --
375: select organization_id, employment_category, payroll_id
376: into l_lnk_org_id, l_lnk_emp_cat, l_lnk_payroll_id
377: from pay_element_links_f
378: where element_link_id = p_element_link_id
379: and p_effective_start_date between
380: effective_start_date and effective_end_date;
381:

Line 1239: pay_element_links_f el,

1235: asg.business_group_id,
1236: el.element_link_id
1237: from per_all_assignments_f asg,
1238: pay_people_groups ppg,
1239: pay_element_links_f el,
1240: pay_people_groups el_pg
1241: where el_pg.id_flex_num = ppg.id_flex_num
1242: and el.business_group_id + 0 = asg.business_group_id
1243: and el.effective_start_date <= asg.effective_end_date