APPS.PAY_INTERPRETER_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,

3481: (
3482: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3483: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3484: p_business_group_id IN per_business_groups.business_group_id%type,
3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3486: p_mode IN VARCHAR2,
3487: p_process IN VARCHAR2,
3488: p_process_mode IN VARCHAR2,
3489: p_event_group_id IN pay_event_groups.event_group_id%type,

Line 3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,

3670: (
3671: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3672: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3673: p_business_group_id IN per_business_groups.business_group_id%type,
3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3675: p_process_mode IN VARCHAR2,
3676: p_event_group_id IN pay_event_groups.event_group_id%type,
3677: p_start_date IN date,
3678: p_end_date IN date,

Line 4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,

4221: (
4222: p_element_entry_id IN pay_element_entries.element_entry_id%type,
4223: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
4224: p_business_group_id IN per_business_groups.business_group_id%type,
4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,
4226: p_process_mode IN VARCHAR2,
4227: p_event_group_id IN pay_event_groups.event_group_id%type,
4228: p_start_date IN date,
4229: p_end_date IN date,

Line 4793: per_all_assignments_f paf

4789: is
4790: select /*+ USE_NL(pgr paf)*/
4791: pgr.grade_rule_id
4792: from pay_grade_rules_f pgr,
4793: per_all_assignments_f paf
4794: where paf.assignment_id = p_assignment_id
4795: and paf.grade_id = pgr.grade_or_spinal_point_id
4796: union all
4797: select /*+ ORDERED USE_NL(pgr psp psps pspp)*/

Line 5929: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;

5925: and et.effective_end_date;
5926:
5927: -- Local variables declaration.
5928:
5929: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;
5930: l_event_group_id NUMBER ;
5931: l_business_group_id NUMBER ;
5932: l_start_date DATE := p_start_date ;
5933: l_end_date DATE := p_end_date ;

Line 6006: from per_all_assignments_f

6002: if (g_business_group_id is null) then
6003: --cache empty so get now
6004: select max(business_group_id)
6005: into l_business_group_id
6006: from per_all_assignments_f
6007: where assignment_id = p_assignment_id;
6008:
6009: -- There is one exceptional circumstance where bg_id is null
6010: -- specifically, a purge of an asg from per_all_assignments_f

Line 6010: -- specifically, a purge of an asg from per_all_assignments_f

6006: from per_all_assignments_f
6007: where assignment_id = p_assignment_id;
6008:
6009: -- There is one exceptional circumstance where bg_id is null
6010: -- specifically, a purge of an asg from per_all_assignments_f
6011: -- if we care that its been purged then weve caught the event so
6012: -- workaround is to get the bg from ppe
6013: --
6014: if ( l_business_group_id is null) then

Line 6229: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;

6225: ) AS
6226:
6227: -- Local variables declaration.
6228:
6229: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;
6230: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
6231: t_dynamic_sql t_dynamic_sql_tab ;
6232: t_proration_dates_temp t_proration_dates_table_type ;
6233: t_proration_change_type_temp t_proration_type_table_type;